Excel N Function
DEFINITION:- The Excel N Function Returns A Value Converted To A Number. The N Function Can Convert True And False To 1 And 0. For A Text Value, The N Function Returns Zero.
Values Are Converted According To The Table Below.
Input ValueReturn ValueTRUE1FALSE0Any Number ValueReturn Same NumberAny Error Code (#VALUE, #N/A, etc)Return Same Error CodeA Valid DateReturn Excel Serial Number FormatAny Other ValuesReturn 0