G
GRK
I have a list of cost ranges and each range has a multiplier.
RANGE Multiplier
$0.00 to $0.99 6.00
$1.00 to $2.99 5.75
$3.00 to $5.99 5.50
$6.00 to $9.99 5.25
If a product has a cost range between 0.00 to 9.99, how do you write the
formula to pick the correct multiplier? If the product cost $2.50 then the
multiplier should be 5.75.
This is what I have and it's not working.
=IF(J7<=.99,6.00,IF(AND(J7>=1.00,J7<2.99,5.75,IF(AND(J7>=3.00,J7<5.99,5.50,IF(AND(J7>=6.00,J7<9.99,5.25))))
Cell J7 is the cost.
Thanks
RANGE Multiplier
$0.00 to $0.99 6.00
$1.00 to $2.99 5.75
$3.00 to $5.99 5.50
$6.00 to $9.99 5.25
If a product has a cost range between 0.00 to 9.99, how do you write the
formula to pick the correct multiplier? If the product cost $2.50 then the
multiplier should be 5.75.
This is what I have and it's not working.
=IF(J7<=.99,6.00,IF(AND(J7>=1.00,J7<2.99,5.75,IF(AND(J7>=3.00,J7<5.99,5.50,IF(AND(J7>=6.00,J7<9.99,5.25))))
Cell J7 is the cost.
Thanks