Excel N Function

HomeExcel FunctionsExcel N Function (Example + Sample File)


The Excel N Function is listed under Microsoft Excel's Information Functions category. It converts a Boolean into a number. In simple words, it converts TRUE into 1 and FALSE into 2. These numbers are the actual value of the boolean values.

How to use it

To learn how to use the N function in Excel, you need to understand its syntax and arguments:




  • value: A Boolean which you want to convert to a number


  • In a real-life, N doesn’t have any use as a separate function as Excel can automatically convert Boolean into numbers where needed.


To master the N function we need to try it out in an example and below is one which you can try out:

In the below example, we have used N function to insert a comment into a formula.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.