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! |
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! |
All times are GMT +1. The time now is 08:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com