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( value)
value : value to be checked
N Function in Excel – Examples
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
Save Up to 85% LIMITED TIME OFFER
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
