Forum Discussion
Solved
Rounding Numbers
I want to know what formula to use in rounding up to 50 or 100 while using IF function in the same cell. For example: 4349 when rounded up to 50, it will be 4350. roundup(cell#,10/0)*10 4399 when ...
You can use the CEILING or CEILING.MATH function for this:
=CEILING.MATH(A1,50)
will round the value of A1 up to the nearest multiple of 50.
You can use the CEILING or CEILING.MATH function for this:
=CEILING.MATH(A1,50)
will round the value of A1 up to the nearest multiple of 50.
Thanks