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

ISNUMBER function

Description

Cell-is-number function. ISNUMBER(var) results in the logical value 1 (=TRUE) if the calculation of var results in a number.

Examples

ISNUMBER(25.6) returns 1

ISNUMBER(B2) returns 0 (=FALSE) if cell B2 contains e.g. the string value "SMITH"

Calculator

ISNUMBER(  

Related functions