N function helps you to convert a Boolean into a number. In below example, we have used it to convert TRUE into 1 and FALSE or any other text into 0.

## Syntax

N(value)

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

## More Information

- In a real life, N doesn’t have any use as Excel can automatically convert Boolean into numbers where needed. But you can use this function to add a comment into a formula.

## Example to use N Function

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

When you input a text in N function it will return 0 which have no effect on calculation and you have a nice technique to insert comments in your formulas for future reference.

Download sample file from here to learn more.

## What’s Next?

To learn more about N Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

Apart from this, you can check these excel functions and some real life formulas examples.