Forum Discussion

packie's avatar
packie
Brass Contributor
Jul 08, 2024

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 be kicking myself when I see the answer 🙂

 

Thank you for taking a look!

 

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 08, 2024

    packie 

    =ISBLANK(E8) will return TRUE if E8 is empty, FALSE otherwise.

    =NOT(ISBLANK(E8)) will return FALSE if E8 is empty, TRUE otherwise.

    • packie's avatar
      packie
      Brass Contributor
      Jul 08, 2024
      Thankyou for your help.

      =NOT(ISBLANK(E8)) worked only when I unchecked "ignore blanks"

Resources