One way:
=CEILING(A1/(1-0.45),10) - 0.01
In article ,
"Brian" <Brian @discussions.microsoft.com wrote:
In excel i want to take a cost divide it by a certian margin then round that
result up to the nearest $9.99...
For example $125 divided by a 45% margin is $227.27
i want it to round up to $229.99
|