Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Too Many If's | Excel Worksheet Functions | |||
How many 'if's'? | Excel Discussion (Misc queries) | |||
to many 'IF's'?? | Excel Worksheet Functions | |||
Formula with multiple IF'S | Excel Discussion (Misc queries) | |||
How many if's? | Excel Discussion (Misc queries) |