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.
Полезна?
Ограничение на знаците: 250
Ограничението за знаци е 250.
Благодарим ви за обратната връзка.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.