Help with Cell Formula

[82whiskey]

I have been trying to accomplish something with an IF statement and I
just can't get it to work so I'm hoping someone here can help me out.
Here is what I'm trying to do.

I have a cell (lets call it A) that needs to pull rates form four
different cells based on criteria form two other cells.

Here is what I need Cell A to do:

Cell B has a numeric value
Cell C has a M or W

If the value in Cell B is "below" 1000 and the value in cell C is "W",
I need to pull from one of the rate cells
If the value in Cell B is "above" 1000 and the value in cell C is "W",
I need to pull from another rate cell

If the value in Cell B is "below" 1000 and the value in cell C is "M",
I need to pull from still another rate cell
If the value in Cell B is "above" 1000 and the value in cell C is "M",
I need to pull from still another rate cell

Hopes this makes sense.

Thanks, Brian

 

[82whiskey]

Hi Harald,

Thanks for your quick response! Works perfectly!

Brian