Rounding Numbers

New Contributor

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!

2 Replies
best response confirmed by allyreckerman (Microsoft)


You can use the CEILING or CEILING.MATH function for this:




will round the value of A1 up to the nearest multiple of 50.