ExcelBanter - If formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If formula (https://www.excelbanter.com/excel-discussion-misc-queries/177892-if-formula.html)

bugalugs

If formula

I don't know how to search on which formula I want - I used to use a 'wizard'
but I can't find this in the excel that I'm currently using (pulls sad face!).

Basically, if the value in one cell is 'YES' I want the other cell to
automatically update to show a value of £20

Gary''s Student

If formula

=IF(A1="YES","£20","")

--
Gary''s Student - gsnu200770

All times are GMT +1. The time now is 10:13 PM.