How to use N Function in Excel

The Excel N function returns a number when given a value. The N function can be used to convert TRUE and FALSE to 1 and 0 respectively. When given a text value, the N function returns zero.

Syntax:= N (value)

The N function syntax has the following arguments:  Value Required. The value you want converted. N converts values listed in the following table.

If value is or refers to N returns
A number That number
A date, in one of the built-in date formats available in Microsoft Excel The serial number of that date
TRUE 1
FALSE 0
An error value, such as #DIV/0! The error value
Anything else

0

Example: Let’s look at some Excel N function examples and explore how to use the N function as a worksheet function in Microsoft Excel:

N Function - How to use N Function in Excel

Syntax:  =N(A2)

Result:

N Function in Excel - How to use N Function in Excel

Based on the Excel spreadsheet above, the following N examples would return:

Syntax: =N(A3)
Result: 0

Syntax: =N(A4)
Result: 0

Syntax: =N(A5)
Result: -2020

Syntax: =N(A6)
Result: 0.003

Syntax: =N(A7)
Result: 44190

Syntax: =N(A8)
Result: 0

Syntax: =N(A9)
Result: #N/A

Note:

  1. When range of cells given as argument, the function only checks the first cell of the array as returns TRUE or FALSE based only on the first cell.
  2. The function returns 1 for TRUE logical value but returns 0 for FALSE.

Add a Comment

Your email address will not be published. Required fields are marked *