< Go Back

Excel N Function

The Excel N function converts the value of a cell into a number.

What is N function in Excel?

The N function in Excel returns a number when a value is given.

How the N function is used in Excel?

The use of the N function is in converting the TRUE and FALSE values to 1 and 0 respectively. The function will return zero if the given value is text. The values are converted according to the following criteria:

Input Value Return Value
Any number Same number
A recognized date A date in EXCEL number format
An error code (#VALUE, #N/A, etc) Same error code
Other values 0

Formula or Syntax


Parameters or Arguments of N function

The argument passed in the function is:

  •         Value: Required. The value to be converted into a number.


Now, let us look at an example to understand how the N function works:

  1. Make a table consisting of different types of values, i.e. any number, text, logical value, a date and an error code.

Figure 1. Make a table for different values

  1. Now, select the corresponding cell and insert the N function. Use the function on the all the values given.

Figure 2. Insert the N function from the Information tab

  1. The result of the N function will be displayed on the corresponding rows of column C.

Figure 3. The results of N function

Note on Usage of N function

The notes on usage of the N function are given below:

  •         The function is not mandatory to use in a formula because Excel converts the value on its own.
  •         Excel stores the dates in a sequential manner so that they can be used in the calculation.
  •         The N function provides compatibility with the spreadsheet programs.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment