ISNUMBERORDATE

The ISNUMBERORDATE function returns the boolean value TRUE if the given expression evaluates to a number or date; otherwise, it returns the boolean value FALSE.

ISNUMBERORDATE(cell)

cell: The value to test.

Examples

If the table cell A1 contains a number (100), B1 contains a string ("Hello"), and C1 contains (1981-03-02):

=ISNUMBERORDATE(A1) returns TRUE.

=ISNUMBERORDATE(B1) returns FALSE.

=ISNUMBERORDATE(C1) returns TRUE.

See alsoISNUMBERISTEXTISDATE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.