rounding formulas
 

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?

rounding formulas
 

=ROUNDUP(A1,-2)


"Junior" wrote:

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?

rounding formulas
 

=CEILING(A1*40%,100)

--
HTH

Bob Phillips

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

"Junior" wrote in message
...
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?