Go Back

The Excel N Function

Figure 1. of Excel N Function

The purpose of the Excel N Function is to convert a value to a number. This is an in-built Function in Excel which we can categorize as an Information Function.

Operation Syntax

N(value)

The parameters of our formula/syntax are as follows

  • Value – A data value which we wish to convert to a number.

Note the following conditions

  1. If our data value = a number, our N Function will be determined as a number value.
  2. If our data value = a calendar date, our N Function will be determined as a serial number.
  3. If our data value = True, our N Function will be determined as 1.
  4. If our data value = False, our N Function will be determined as 0.
  5. If our data value = Error, our N Function will be determined as an Error.
  6. For any and all other types of data value, our N Function will be determined as 0!, or same.  

How to use the N Function in Excel

Based on the Excel worksheets displayed below, the attached N operation syntax would be determined as;

Figure 2. of Excel N Function

=N(A2)

-Determined as 1.

Figure 3. of Excel N Function.

=N(A3)

-Determined as 0

Figure 4. of Excel N Function.

=N(A4)

-Determined as 500

Figure 5. of Excel N Function.

=N(A5)

-Determined as 0

Figure 6. of Excel N Function.

=N(A6)

-Determined as 0

Figure 7. of Excel N Function.

=N(A7)

-Determined as 0

Figure 8. of Excel N Function.

=N(A8)

-Determined as same value/0!

The Excel N Function is a worksheet Function and is usually entered into an Excel worksheet as part of a formula.

Instant Connection to an Expert through our Excelchat Service

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

hi expert, how will you write this in excel? n=777 ans = [100+(n)]+[100+(n-1)]+[100+(n-2)]+[100+(n-3)]+...+[100+(n-n)] Thank you for any help that you can provide! Regards, Vaan
Solved by B. S. in 14 mins
Qty Part Number Description Price Total Subtotal: #N/A 1 3009 ALFALFA, LEAF, Powder $3.05 3.05 Tax: #N/A Total Order: #N/A Qty Part Number Description Price Total Subtotal: #N/A 1 AFRICAN BIRD PEPPER, FRUIT, Whole #N/A #N/A Tax: #N/A Total Order: #N/A I want the formula to read as the second part
Solved by B. H. in 18 mins
I am trying to use the following formula to sum a column of six items if any item is nonzero but show nothing if they are all zero. If the first, second or sixth item is nonzero, it works. But if the those three are zero, the sum ignores the third, fourth, and fifth items. Here is the formula: =IF(N(F56)*N($J$2)+N(F57)*N($J$3)+N(F58)*N($J$4)+N(F59)*($J$5)+N(F60)*N($J$6)+N(F61)*N($J$7)=0,"",SUM(F56:F61))
Solved by C. Q. in 12 mins

Leave a Comment

avatar