N

See also A-Z Spreadsheet Function List

Description Tests the supplied value and returns the value if it is a number.

Syntax N(value)

value is a value or a reference to a cell containing a value to test.

Remarks Numbers are returned as numbers, serial numbers formatted as dates are returned as serial numbers, and the logical function TRUE() is returned as 1. All other expressions return 0.

See Also T and VALUE functions

Examples N(32467) returns 32467

         N(A4) returns 1 if A4 contains the logical function True