This post will guide you how to use Excel N function with syntax and examples in Microsoft excel.
The Excel N function converts a value to a numeric value. And the N function can be used to convert the logical value TRUE as 1 and false value as 0. If you try to convert a text value, and the N function will return 0.
The N function is a build-in function in Microsoft Excel and it is categorized as an Information Function.
The N function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.
The syntax of the N function is as below:
Where the N function argument is:
- Value – This is a required argument. The value that you want to convert.
N converts values listed in the following table.
|If value is or refers to
|A date, in one of the built-in date formats available in Microsoft Excel
|The serial number of that date
|An error value, such as #DIV/0!
|The error value
Excel N Function Example
The below examples will show you how to use Excel N Function to convert a value to a number.
#1 to convert the value in Cell B1 that contains a number, and the number will be returned, using the following formula:
= N (B1)
#2 to convert the value in Cell B2 that contains text, and the zero will be returned, using the following formula:
= N (B2)
#3 to convert the value in Cell B3 that contains a logical value TRUE, and 1 is returned, using the following formula:
= N (B3)
More Excel N Function Examples
- Count Number of Cells with String Length greater than X
You can create a new formula based on the SUMPRODUCT function, the N function and the LEN function to check the string length of each cell and also get the total number that the string length is greater than number 10.……