IF

[RussChilds]

Hi,
I have a column A which states either Yes or No. I want to set up column B to say IF column = Yes then £20 but if coulmn A = No then £40.

Many thanks!!!

 

[mikerickson]

Does = IF(A1="Yes",20,40) do what you want?

 

[VoG]

Try

=IF(A1="Yes",20,IF(A1="No",40,""))

and format the result cells as Currency.

 

[RussChilds]

Thanks!!!!!!!!

 

[stanleydgromjr]

RussChilds,

Excel Workbook
	A	B
1	Yes	$20
2	No	$40
3
Sheet1

Format cells in column B for Pounds.


Have a great day,
Stan