Forum Discussion
warn when cell is blank
Hi, =ISBLANK(E8) The above formula will warn if E8 contains a value What formula do I need if E8 does not contain a value I have been struggling with this for a while now. I will b...
=ISBLANK(E8) will return TRUE if E8 is empty, FALSE otherwise.
=NOT(ISBLANK(E8)) will return FALSE if E8 is empty, TRUE otherwise.
Thankyou for your help.
=NOT(ISBLANK(E8)) worked only when I unchecked "ignore blanks"
=NOT(ISBLANK(E8)) worked only when I unchecked "ignore blanks"
You hadn't mentioned that this was for Data Validation...
- Your right I should have mentioned that, sorry. My bad.