Try:

=IF(J7<=0.99,6.00,IF(J7<2.99,5.75,IF(J7<5.99,5.50, IF(J7<9.99,5.25,1))))

You didn't say what multiplier applies if the cost =$10.00. I assumed 1.
Change to suit. BTW, your formula didn't work because you left out the end
parentheses ")" after each of the AND functions.

Greg

"GRK" wrote:

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(A ND(J7=3.00,J7<5.99,5.50,IF(AND(J7=6.00,J7<9.99,5 .25))))

Cell J7 is the cost.

Thanks
--
GRK