N
Description
N tests the supplied value and returns the value if it is a number.
Syntax
N ( value )
|
Parameter |
Description |
|
value |
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.
Examples
This function returns 32467:
N(32467)
This function returns 1 if A4 contains the logical function TRUE:
N(A4)
Also, see