G
Guest
I am really close to an accurate conditional formula, but it seems to be
missing the middle part of the formula when put into action. The scenerio is
this:
Column "C" are all prices on my spreadsheet.
I need shipping and handling of .6 multiplied to each price plus three
different margins depending on price. (anything over $2.00 is to have a 30%
margin, anything between $1.50 and $2.00 is to have a 35% margin, and
everything below $1.50 is to have a 40% margin) SO, MY FORMULA LOOKS LIKE
THIS:
=IF(C6>2,C6*.6/.70,IF(OR(C6<2,C6>1.5,C6*.6/.65,C6*.6/.60))
This formula seems to pick up all prices over $2.00 and all prices below
$1.50, but if the price in column "C" is between $1.50 and $2.00 it doesn't
pick up the middle of this formula to give me the margin of 35%?
Can someone figure out what I need to change to get this middle argument to
work?
I really appreciate it,
Lisa
missing the middle part of the formula when put into action. The scenerio is
this:
Column "C" are all prices on my spreadsheet.
I need shipping and handling of .6 multiplied to each price plus three
different margins depending on price. (anything over $2.00 is to have a 30%
margin, anything between $1.50 and $2.00 is to have a 35% margin, and
everything below $1.50 is to have a 40% margin) SO, MY FORMULA LOOKS LIKE
THIS:
=IF(C6>2,C6*.6/.70,IF(OR(C6<2,C6>1.5,C6*.6/.65,C6*.6/.60))
This formula seems to pick up all prices over $2.00 and all prices below
$1.50, but if the price in column "C" is between $1.50 and $2.00 it doesn't
pick up the middle of this formula to give me the margin of 35%?
Can someone figure out what I need to change to get this middle argument to
work?
I really appreciate it,
Lisa