Hi Biff,
I didn't know that you could put constants straight into a VLOOKUP formula.
Can't see that in the Help. It makes a very handy and compact stand-alone
formula when the lookup array is small.
Regards - Dave.

"T. Valko" wrote:

Try this:

=LOOKUP(J7,{0,1,3,6},{6,5.75,5.5,5.25})

Note that any number greater than or equal to 6 will return 5.25. 1000000
will return 5.25.

--
Biff
Microsoft Excel MVP


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