rounding formulas

J

Junior

I know if I want to do a formula for rounding to the nearest 100 of 40% of a
number it's =ROUND(a1*40%,-2). This will automatically round to the nearest
100. However, I am looking to round to the next highest 100 so if the value
is 2,101 it will round up to 2,200. Any ideas?
 
B

Bob Phillips

=CEILING(A1*40%,100)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top