Hi!

Here's one way:

=CEILING(125/0.45,10)-0.01

Or:

=CEILING(A1/B1,10)-0.01

For example $125 divided by a 45% margin is $227.27

A1 = 125
B1 = .45
C1 = A1/B1 returns 277.7777778

Biff

"Brian" <Brian @discussions.microsoft.com wrote in message
...
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