| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Cell Formula
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Cell Formula
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+(B11000)*(C1="W")*A2+(B1< =1000)*(C1="M")*A3+(B11000)*(C1="M")*A4 HTH. Best wishes Harald "82whiskey" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Cell Formula
Hi Harald,
Thanks for your quick response! Works perfectly! Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract cell formula from existing cell formula | Excel Programming | |||
| get the value of a formula in cell B1 into cell A1 without changing my current cell selection | Excel Programming | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Linear Mode
