| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If formula
=IF(A1="YES","£20","")
-- Gary''s Student - gsnu200770 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
