N

Description

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

Syntax

N ( value )

Parameter Description
value The 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:

N(TRUE())

See also

T

VALUE