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

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

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

"Lee" wrote:
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.

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?

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

=CEILING(A1, 0.05)