formula help

  • Thread starter Thread starter Bob Bob
  • Start date Start date
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
 
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
 
Back
Top