IF Condition Query

[nortellini]

Good morning/evening everyone!

I am trying to create an IF query to return a certain value if a condition is satisifed. As follows:

If Column A equals 'Yes', I would like to populate Column D with the value of Column B.

However, if Column A equals 'No', I would like to populate Column D with the value of Column C.

I am clearly a moron with no grasp for simple formula - can one of you more enlightened and helpdeul people advise?

Many many thanks in advance

Regards

Chris

 

[njimack]

Assuming your data starts in row 1, formula in D1: =IF(A1="Yes",B1,C1)

 

[barry houdini]

Could there be a blank or something other than "Yes" or "No"? Perhaps

=IF(A1="Yes",B1,IF(A1="No",C1,""))