Forum Discussion
Excel Formulas
Can anybody please help me. I have a spreadsheet that when a document is sent out a date is entered into a column, I also have another column where I have to manually type in yes when the date is entered (the document has gone).
My question is, can a formula be added to the yes column, so that it automatically is filled with yes when the date cell is entered?
2 Replies
Another variant is to use
=--(A1>1)
and apply custom format
First, your 'Yes' column sounds a bit redundant? Filter the date column for blanks or not blanks and you have the same information?
But to answer your question, this will do it. (assume your date is in A1, you will need to change that to match your table). =if(A1="","","Yes")
Copy that down your yes column.
