Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF, THEN statement
I have 4 columns, B, C, D, E. Would like a statement that would calculate
this way: if cell C1 has a "1" in it, put the value of what appears in B1 into a resultant cell D1. But if cell C1 has a "2" in it, put the value of what appears in B1 into a resultant cell E1. Example is that B1 has a figure such as 25. Cell C1 has the value 1, so D1 would result in 25. But if B1 has that same figure of 25 and C1 has the value of 2, then E1 would result in 25. Thanks! |
#2
|
|||
|
|||
You need multiple formulas
D1: =IF(C1=1,B1,"") E1: =IF(C1=2,B1,"") -- HTH Bob Phillips "John Sullivan" wrote in message ... I have 4 columns, B, C, D, E. Would like a statement that would calculate this way: if cell C1 has a "1" in it, put the value of what appears in B1 into a resultant cell D1. But if cell C1 has a "2" in it, put the value of what appears in B1 into a resultant cell E1. Example is that B1 has a figure such as 25. Cell C1 has the value 1, so D1 would result in 25. But if B1 has that same figure of 25 and C1 has the value of 2, then E1 would result in 25. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions |