if my cost is less than 2.00...divide the cost by .68
If the cost is between 2.00 and 3.00...divide the cost by .7
if the cost is greater than 3.00...divide by .77
=A1/CHOOSE(A1,0.68,0.7,0.77)

That will return an incorrect result when the cost is <1, when the the cost
=3 and when the cost is =4.

Did you even test that?

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
Hi,

If your cost is in A1, in B1 enter the formula

=A1/CHOOSE(A1,0.68,0.7,0.77)

and format the cell to 2 decimals.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Frustratedpricer" wrote:

I'm working on changing my retail price lists. I want to take my cost
plus