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 Value | Return Value |
|---|---|
| TRUE | 1 |
| FALSE | 0 |
| Any Number Value | Return Same Number |
| Any Error Code (#VALUE, #N/A, etc) | Return Same Error Code |
| A Valid Date | Return Excel Serial Number Format |
| Any Other Values | Return 0 |
