Round off
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
-
Try using the ROUNDUP function:
=ROUNDUP(AVG(COLLECT([Duration (Day)]:[Duration (Day)], Status:Status, "Booked", [Date Booked]:[Date Booked], IFERROR(MONTH(@cell), 0) = 11)))
Answers
-
Try using the ROUNDUP function:
=ROUNDUP(AVG(COLLECT([Duration (Day)]:[Duration (Day)], Status:Status, "Booked", [Date Booked]:[Date Booked], IFERROR(MONTH(@cell), 0) = 11)))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!