rounding formulas

[Guest]

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?

 

[Guest]

=ROUNDUP(A1,-2)

 

[Bob Phillips]

=CEILING(A1*40%,100)

--
HTH

Bob Phillips

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