Thank you David. I'm not clear on your formula. There are actually 10
levels of margins, with the highest one being for anything over $19.00. I
was hoping that when I got an answer I would be able to fill in the rest, but
I'm not getting your pattern.

Here are the general markup rates, if that would help.

<$1.00 = 500%
$1.01 - $3.00 = 400%(*5)
$3.01 - $5.00 = 300%(*4)
$5.01 - $7.00 = 200%(*3)
$7.01 - $9.00 = 100%(*2)
$9.01 - $11.00 = 90%(*1.9)
$11.01 - $13.00 = 80%(*1.8)
$13.01 - $15.00 = 60% (*1.6)
$15.01 - $17.00 = 50%(*1.5)
$17.01 - $19.00 = 40%(*1.4)
$19.01 - Up = 32%(*1.32)

"David Billigmeier" wrote:

What happens to items that are $5? Marked up by 200% (*3)? Here is a
formula you can use to your specifications so far, assuming that:

=A1*IF(A1<=1,6,IF(A1<=3,5,IF(A1<=5,4,3)))

--
Regards,
Dave


"Nancy" wrote:

I'm trying to make a formula that will calculate a markup on goods sold.
Items below $1 are marked up 500% (*6), $1.01-$3 are 400% (*5), $3.01 - $5.00
are 300% (*4), etc.

How can I create a formula that will look at our cost for an item in cell B1
and return the correct standard markup in another cell according to the
original cost?

I had started out with:

=OR(IF(B1<1, B1*6, 0)),IF(AND(B1.99, B1<3.01), B1*5,0),IF(AND(B13.00,
B1<5.01),B1*4,0))

But it didn't work for me.

TIA