Round off

Marilen.Navarro103391

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.

Paul Newcome

Try using the ROUNDUP function:

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

Paul Newcome

Try using the ROUNDUP function:

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