N function
N returns the number 1 if the parameter is TRUE. N returns the parameter if the parameter is a number. N returns the number 0 for other parameters. If an error occurs, the function returns a logical or numerical value.
Syntax
N(value)
value is the parameter to be converted into a number.
Example
=N(TRUE) returns 1.
=N(FALSE) returns 0.
=N(100) returns 100.
=N("abc") returns 0.