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: