close
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
quot;Leequot; wrote:
gt; If I have a value of $10 and add 10% by dividing by 0.90,
gt; I get $11.11 which I would like to round up to the
gt; nearest $0.5, i.e. $11.15.
From your example, I presume you mean quot;nearest $0.05quot;
(nickel).
gt; Does anybody know the formula and can you use it on a
gt; result which is also a formula?
If you truly mean quot;round upquot;, as your example might suggest:
=CEILING(A1, 0.05)
全站熱搜
留言列表
