Excel N function

Function              N

Description        Excel N function returns a number when a value supplied. The N function is used to convert TRUE and FALSE to 1 and 0 respectively. When given a text value, the N function returns zero. In case of date and time value it returns serial number.

Syntax  N(value)

value  The reference cell or value to convert into number.

Example: