How to Use Excel N Function (5 Examples)

Oftentimes you have to move your Microsoft Excel workbook or file to another spreadsheet program that runs on a different operating system. In such cases, you might face some compatibility issues. Microsoft Excel has a function named N function which will help you avoid such compatibility issues. The N function in Excel will convert an input value to a number. In this article, we will explain how to use the N function in Excel to make our Excel file compatible with other worksheet programs. Here’s an overview of the function;

How to Use Excel N Function


Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.


Introduction to the N Function

N Function in Excel

â–¶ Function Objective

N function in Excel is a text function that will return a number when we provide a value. The function can be used to convert logical or Boolean values TRUE or FALSE into 1 and 0 respectively. It is a function with limited use and is primarily used to ensure compatibility with other spreadsheet programs.

â–¶ Syntax

=N(value)

â–¶ Argument Explanation

Argument Required/Optional Explanation
value Required The value you want to be converted.

â–¶ Return Parameter

Returns a value converted to a number


5 Suitable Examples of N Function in Excel

N function Excel can convert Numbers, Dates, Text, Logical values, and Other types of characters to make the Excel file compatible with other types of Spreadsheet programs.

1. N Function Does Not Affect Any Numerical Values or Errors

If we write the following formula in cell D5

=N(C5)

Here,

C5 = 100 = A Number

How to Use Excel N Function

We will find that the N function returns the same number. N function does not affect the numerical values and always returns the same number.

Function Does Not Affect Number

N function does not also affect the error and returns the same error code every time.

 Convert Error Code to Zero


2. Convert a Date Using the N Function in Excel

Insert the following formula in cell D5

=N(C5)

Here,

C5 = 05-01-2022 (5th January 2022) = A date in one of the built-in date formats available in Microsoft Excel

Convert Date to Serial Number

We will find that the N function converts the date to the serial number of the date.

Convert a Date Using the N Function in Excel

Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 5, 2022, is serial number 44,566 because it is 44,566 days after January 1, 1900.


3. N function Converts Text to Zero

Write the formula below in cell D5

=N(C5)

=N(C5) = Exceldemy =  A Piece of Text

Converts text to zero

We will find that the N function converts the text to Zero (0).

Convert Text to Zero Using N Function


4. N Function Converts Logical Values to 1 and 0

Enter the following formula in cell D5

=N(C5)

Here, C5 = TRUE = Logical Value

N function converts Logical Values to 1 and 0

We will find that the N function converts TRUE to One (1) and FALSE to Zero (0).

Convert Logical Values to One or Zero


5. N function Converts Other Values to 0

 Write down the following formula in cell D5

=N(C5)

Here, C5 = #$% = Various Characters

Converts Various Characters to 0

We will find that the N function converts the string of characters to Zero (0).

Convert Other Types


Things to Remember

  • It is not generally necessary to use the N function in a formula because Excel automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.
  • The N function removes text values. The T function removes numeric values.

Conclusion

In this article, we have learned to use the N function in Excel to return a number when a value is provided. The N function in Excel helps the Excel file to be compatible with other spreadsheet programs. If you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!!

Tags:

ASM Arman

ASM Arman

Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!!

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo