What is the use of N function?

N Function in Excel converts data into numeric values, converts a non-number value to a number, a date to a serial number, the logical value TRUE to 1 and all other values to 0

What is the syntax of N function?

N Function in Excel - Syntax

N( value)

value : value to be checked

N Function in Excel – Examples

N Function in Excel - Example 1

Example 1: Returns serial number for given data
Example 2: Returns 1 as the given value is logical TRUE
Example 3: Returns 0 as it is not a number/logical TRUE/ date
Example 4: Returns number as the given value is a number
Example 5: Returns 0 as it is not a number or logic or date

Reference:

Please refer the below article for more Information Excel functions.
Information Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home