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!