Explanation
The N function takes a value and returns a number.
When given a text value, the N function returns zero.
Related functions
N Function
The Excel N function returns a number when given a value.
The N function can be used to convert TRUE and FALSE to 1 and 0 respectively.
When given a text value, the N function returns zero.
