Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

ISMISSING function


Cell-is-missing function. ISMISSING(var) returns the logical value 1 (=TRUE) if the calculation of var does not result in a numeric or text value, or var equals a user-defined missing value (see USRMISSING function).


ISMISSING(B2) returns 0 (=FALSE) if cell B2 contains a number or a string value, e.g. "SMITH".

ISMISSING(25.6) returns 0

Related functions