ISNUMBER(X)

 

Description

This function returns 1 if X is a numeric value; otherwise, it returns 0.  Blank cells are considered numeric.

 

Parameters

 

X

A numeric value.

 

Examples

 

ISNUMBER(C10) = 0

Where C10 = "Total".

 

ISNUMBER(D10) = 1

Where D10 = 1000.00.

 

ISNUMBER(A1) = 1

Where A1 is blank.