Help with Cell Formula

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
 
H

Harald Staff

Hi Brian

Absolutely. Rate cells A1 to A4, containing numerical (!) values. Number in
B1 and M or W in C1. Formula:

=(B1<=1000)*(C1="W")*A1+(B1>1000)*(C1="W")*A2+(B1<=1000)*(C1="M")*A3+(B1>1000)*(C1="M")*A4

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top