formula help

[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 Culver]

Assuming it's either Y or N:
=if(D1=Y,B1,C1)

Ross

 

[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