# Excel N Function

HomeExcel FunctionsExcel N Function (Example + Sample File)

## What is EXCEL N FUNCTION

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:

N(value)

### Arguments

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

### Notes

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

## Example

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: