N

Syntax:

N ( value )

Description: Converts value to a number or, if value is a reference to a single cell, converts the value of that cell to a number.

Arguments:

Name

Type

Description

value

any

Value to be converted.

Return Type and Value: number or error – An integer that is the converted value of value, or, if value is a reference to a single cell, the converted value of that cell, as follows:

value

Value Returned

number

That number

TRUE

1

FALSE

0

error value

That error value

Anything else (including array and text)

0

example: