ISNUMBERP (PlanMaker 97 compatibility function)

<< Click to Display Table of Contents >>

ISNUMBERP (PlanMaker 97 compatibility function)

Syntax:

ISNUMBERP(Value)

Description:

Returns TRUE if the specified value is a number or a logical value.

Dates are considered as numbers as well.

Note:

This function was retained only for compatibility with PlanMaker 97. Using the Excel-compatible function ISNUMBER (without "P") is recommended instead.

The difference:

ISNUMBERP treats logical values as numbers, whereas ISNUMBER does not.

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Example:

If the cells A1 to A4 contain the values:

"Text", 42, 09/25/2018 and TRUE

The following applies:

ISNUMBERP(A1) returns FALSE

ISNUMBERP(A2) returns TRUE

ISNUMBERP(A3) returns TRUE

ISNUMBERP(A4) returns TRUE (!)

For comparison: ISNUMBER(A4) returns FALSE

See also:

ISNUMBER