The Excel N function converts the value of a cell into a number.

**What is N function in Excel?**

The N function in Excel returns a number when a value is given.

**How the N function is used in Excel?**

The use of the N function is in converting the TRUE and FALSE values to 1 and 0 respectively. The function will return zero if the given value is text. The values are converted according to the following criteria:

Input Value | Return Value |

Any number | Same number |

A recognized date | A date in EXCEL number format |

TRUE | 1 |

FALSE | 0 |

An error code (#VALUE, #N/A, etc) | Same error code |

Other values | 0 |

**Formula or Syntax**

**=N(value)**

**Parameters or Arguments of N function**

The argument passed in the function is:

- Value: Required. The value to be converted into a number.

**Example**

Now, let us look at an example to understand how the N function works:

* Figure 1. Make a table for different values*

*Figure 2. Insert the N function from the Information tab*

*Figure 3. The results of N function*

**Note on Usage of N function**

The notes on usage of the N function are given below:

- The function is not mandatory to use in a formula because Excel converts the value on its own.
- Excel stores the dates in a sequential manner so that they can be used in the calculation.
- The N function provides compatibility with the spreadsheet programs.

## Leave a Comment