Rounding up

[AlanL]

Do anyone have a formula that will round up to the nearest nickel? Ex round up $1.62 to $1.65 or $2.01 to $2.05. I cannot seem to get it with the roundup function.

 

[Steve=True]

=CEILING(A2,0.05*A2/ABS(A2))

Steve=True

 

[AlanL]

Thank you so much Steve=True

 

[jasonb75]

Or you could use

=CEILING(A2,0.05*SIGN(A2))

Which eliminates the risk of any #DIV/0! errors.

 

[Steve=True]

nice one jason!

 

[jasonb75]

nice one jason!

I do come out with some good answers occasionally, just not as often as bad ones

 

[abmati]

Will follow

 

[pgc01]

Do anyone have a formula that will round up to the nearest nickel? Ex round up $1.62 to $1.65 or $2.01 to $2.05. I cannot seem to get it with the roundup function.

Just out of curiosity, if you wanted to use the RoundUp() function, try:

=ROUNDUP(2*A1,1)/2