# The N Fuction in #Excel

Here are three uses of the N function in Excel:

There are many uses of the N function in Excel, but here are just three:

1) Convert TRUE or FALSE to 1 or 0
2) Determine the serial number of a date
3) Add a note to a formula

Convert TRUE or FALSE to 1 or 0

The formulas in cells F3 & F4 produce a TRUE and a FALSE:

If I wrap those in the N function, it will convert them to 1 and 0:

Determine the serial number of a date

Using the N function for a date will return the serial number of that date:

Add a note to a formula

You may have a crowded worksheet with no place to add a title to describe the values in a cell. With the N function, you can add a note right in the formula so that by clicking on that cell, you can see some information about the data:

These are just three uses of N. I hope one or more can be useful for you.

Happy Excelling!

### 2 Responses to The N Fuction in #Excel

1. Arun February 15, 2014 at 11:02 am #

Great tutorial on Excel inbuilt function. But the video in YouTube is completely blurred and its difficult to understand.

• Michael Rempel February 15, 2014 at 1:03 pm #

I’m sorry you are having trouble viewing the video. I just checked it again and it clears on my computer after about 10 seconds in. It may just be a function of your internet speed.