If formula

B

bugalugs

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
 
Top