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
An error value, such as #DIV/0! The error value
Anything else


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:

Syntax:  =N(A2)


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


  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 *