<< 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: