Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

A Null value cell displays as a blank cell, but contains characters that do not display. Characters like an apostrophe or ="" display as blanks, but aren't blanks. Using the ISBLANK function to check a cell will return FALSE on a Null value, the same as a legitimate value.

To test for a blank, see Use the ISBLANK function.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.