Round off

Options

Could you assist me?

Formula:

=AVG(COLLECT([Duration (Day)]:[Duration (Day)], Status:Status, "Booked", [Date Booked]:[Date Booked], IFERROR(MONTH(@cell), 0) = 11))

Answer is 1.83

How do I round off .83 to 1. so answer should be 2.

Thanks.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!