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!
|