Forum Discussion
If and statement
Hello! I needed assistance with creating a formula cell o2, essentially, I need "yes or no" to auto populate IF there is a date in symptom onset (q2) AND M2 is not blank, otherwise I just want the cell to be blank.
essentially, I need "yes or no" to auto populate IF there is a date in symptom onset (q2) AND M2 is not blank, otherwise I just want the cell to be blank.
A little more description of conditions is needed, I think. You want one of three results in cell O2
- yes
- no
- blank
but you only give two conditions: it's to remain blank unless there's a date in Q2 and M2 is not blank, but what combination of Q2/M2 creates the "Yes" and what creates the "No"?
