Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if command
i'm trying to make an if command work. i'm trying to make it look to see if a
number in a cell is between two numbers and then send it to another to be multiplied . if the number is 1-11 look at one cell if its 12-23 look at another and so on. my goal is to have something like this: (a1+a1+b1=b1) * (look at what c cell number range is and send it to the corresponding cell to be multiplied) i have to link what i multiply to this cell and can't be in the formula because the number i multiply it by is its own formala and constantly changes. if that makes any sense to anybody. thanks in advance for anybody with any ideas. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if command
You could use nested IFs as long as it doesn't exceed 7.
=(A1+A1+B1)*IF(C1<=11,"CorrespondingCell1",IF(C1<= 23,"CorrespondingCell2")) Otherwise, you should probably look into VLOOKUP. HTH, Paul -- "chris832" wrote in message ... i'm trying to make an if command work. i'm trying to make it look to see if a number in a cell is between two numbers and then send it to another to be multiplied . if the number is 1-11 look at one cell if its 12-23 look at another and so on. my goal is to have something like this: (a1+a1+b1=b1) * (look at what c cell number range is and send it to the corresponding cell to be multiplied) i have to link what i multiply to this cell and can't be in the formula because the number i multiply it by is its own formala and constantly changes. if that makes any sense to anybody. thanks in advance for anybody with any ideas. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if command
yeah , your right. good idea
"PCLIVE" wrote: You could use nested IFs as long as it doesn't exceed 7. =(A1+A1+B1)*IF(C1<=11,"CorrespondingCell1",IF(C1<= 23,"CorrespondingCell2")) Otherwise, you should probably look into VLOOKUP. HTH, Paul -- "chris832" wrote in message ... i'm trying to make an if command work. i'm trying to make it look to see if a number in a cell is between two numbers and then send it to another to be multiplied . if the number is 1-11 look at one cell if its 12-23 look at another and so on. my goal is to have something like this: (a1+a1+b1=b1) * (look at what c cell number range is and send it to the corresponding cell to be multiplied) i have to link what i multiply to this cell and can't be in the formula because the number i multiply it by is its own formala and constantly changes. if that makes any sense to anybody. thanks in advance for anybody with any ideas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
What command to use? | Excel Worksheet Functions | |||
Command T-ONE | Excel Discussion (Misc queries) | |||
Command | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |