rounding formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=CEILING(A1*40%,100)

--
HTH

Bob Phillips

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