Formula to enter to round an Excel value up to the next $0.5?

L

Lee

If I have a value of $10 and add 10% by dividing by 0.90, I get $11.11 which
I would like to round up to the nearest $0.5, i.e. $11.15.

Does anybody know the formula and can you use it on a result which is also a
formula?

Thanks,

Lee
 
J

joeu2004

Lee said:
If I have a value of $10 and add 10% by dividing by 0.90,
I get $11.11 which I would like to round up to the
nearest $0.5, i.e. $11.15.
Click to expand...

From your example, I presume you mean "nearest $0.05"
(nickel).
Does anybody know the formula and can you use it on a
result which is also a formula?
Click to expand...

If you truly mean "round up", as your example might suggest:

=CEILING(A1, 0.05)
 
Top