formula help

B

Bob Bob

I need a formula for cell A1 to show what is in cell B1 when cell D1 has Y
and and shw what is in cell C1 when cell D1 has N.

Thanks to all
 
B

Bernard Liengme

Ross has an answer but we need quotes: =if(D1="Y",B1,C1)
If Y and N are not the only possibilities, then
=if(D1="Y",B1,IF(D1="N",C1,""))
best wishes
 
Top