Rounding Numbers

[aznald101]

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 · Accepted solution]

@aznald101 

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.

[#3]

Thanks