View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Susan Susan is offline
external usenet poster
 
Posts: 271
Default Nine IF's in a formula

I was trying to write a formula with 9 if's in the formula but am not able to
can someone help me please:

Is there a formula which would be more concise that would just say round any
number up to the next decimal that would end in ._ 9. In other words we want
every scenario:

..00 - .09 = .09
..10 - .19 = .19
..20 - .29 = .29
and so on up to .90 - .99 = .99

Any help would be appreciated

Thank you!