Very basic Excel 'IF' formula....am dissapointed to have to ask the solution to.

Dear Spreadsheet Superiors,

Objective is to fill cells in Column 'C'.

If a cell in Column 'B', has the word 'Yes', then the adjacent cells in column C, are populated with the values(text), from column A. Screen shot attached.

I thought the correct Formula, entered into cells in column 'C', was : =IF(B2=''Yes'',A2). But this does not work.
Capture.jpg
Any thoughts greatly appreciated.

Thanks.

Thanks for quick reply. See sample workbook attached.

Hi,
=IF(B2="Yes",A2,"")
You should use " " " notation not single " ' " two times .

Punnam

Great,

Thanks so much. Fantastic response.