SOLVED

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)
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.

Thanks