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 rounded up to 100, it will be 4400. roundup(cell#,100/0)*100
I want to know what formula can be use on the same cell that will automatically determine which roundup formula from above will be used?
Thank you!
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.
2 Replies
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
