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.



value is the parameter to be converted into a number.


=N(TRUE) returns 1.

=N(FALSE) returns 0.

=N(100) returns 100.

=N("abc") returns 0.