price list changes using conditional functions?

  • Thread starter Thread starter Frustratedpricer
  • Start date Start date
F

Frustratedpricer

I'm working on changing my retail price lists. I want to take my cost plus
tax and shipping and create conditional profit margins. For example, if my
cost is less than 2.00, I want to divide the cost by .68. If the cost is
between 2.00 and 3.00, I want to divide the cost by .7, and if the cost is
greater than 3.00, I want do divide by .77. It's important that the format
stays the same, so I can still easily print out my price tags. So, I want
Excel to look at my cost, evaluate what margin it should be at, and enter the
correct retail price in the next cell. Can anyone help> I'm using Excel 2003.
Thanks!
 
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 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)
Click to expand...

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?
 
Back
Top