N function in Excel

Description

Converts a value to a number, using following rules:

If value is or refers to N returns
A number That number
A date, in one of the built-in date formats available in Microsoft Excel The serial number of that date
TRUE 1
FALSE 0
An error value, such as #DIV/0! The error value
Anything else 0

Source: Microsoft Office website

 Syntax

=N(value)

Where (value) is a value to convert to a number

Purpose

Excel by default converts values to numbers, like Jan 01, 1900 is serial number 1 and Jan 09, 2017 is serial number 42736 because there are 42736 days after Jan 01, 1900. The N function is used for comparability with other spreadsheets programs.

Example

Formulas:

Results:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved