8
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
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