Hi,

In B2:B3, enter 32 and 34. In C2:C3, enter 1.38 and 1.37. In B5, enter
32.23. In C5, use the following formula

=B5*vlookup(B5,$B$2:$C$3,2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Grammie" wrote in message
...
I have a rate chart which covers different values, such as:

If the rate is between 32.00 and 33.99 then the cost is multiplied by
38% (1.38).
If the rate is between 34.00 and 35.99 then the cost is multiplied by
37% (1.37)

I want excel to automatically give me the resulting figure when I put
in the rate, so that when it sees $32.23, it knows to multiply by 1.38
and automatically give me the resulting value of 44.32.

Anyone out there that can help, I appreciate it.