I tried that in my sheet. A1 had a value of $0.50 and the result came back
as 0.00.

Thanks anyway...


"Bob Phillips" wrote:

Nancy,

Try this

=A1*VLOOKUP(A1,{0,6;1,5;3,4;5,3;7,2;9,1.9;11,1.8;1 3,1.6;15,1.5;17,1.4;19,1.3
2},2)

--
HTH

RP
"Nancy" wrote in message
...
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