Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
What is the N Function?
The N Function[1] is categorized under the Text functions in Excel. It will return a number when we provide a value. The function can be used to convert logical values TRUE and FALSE into 1 and 0, respectively.
As a financial analyst, the N function offers limited use, as MS Excel automatically converts values as necessary. The function is provided for compatibility with other spreadsheet programs.
Formula
=N(value)
The formula uses only one argument:
Value (required argument) – This is the value that we wish to convert.
The N function will convert data into a numeric value, using the following rules:
Input values
Return value
Any number
Same number
A recognized date
A date is converted into Excel serial number format
TRUE
1
FALSE
0
An error code (#VALUE, #N/A, etc.)
Same error code
Other values
0
In Excel, dates are stored as sequential serial numbers so that we can use them in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2018 is serial number 43101, as it is 43,101 days after January 1, 1900.
How to use the N Function in Excel?
The N function is a built-in function in MS Excel. As a worksheet function, it can be entered into a formula in a worksheet cell.
To understand the uses of the function, let us consider an example:
Example 1
Suppose we are given the following data. Let us see how the function works:
We get the results below:
To show results for formulas in Excel, select the formulas, press F2, and then press Enter. If needed, you can increase the column width(s) to see all the results.
Thanks for reading CFI’s guide to the Excel N function. By taking the time to learn and master these functions, you’ll significantly speed up your financial modeling. To learn more, check out these additional CFI resources:
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.