Related Topics:

Spreadsheet Math Functions

Formulas Tab and Insert Function

Data Entry Tips for Functions

Function Wizard

N

Description: Converts the specified value to a number. For example, if the value is a date, returns the serial number; if the value is TRUE, returns 1; if the value if FALSE, returns 0.

Syntax: N(Value)

If Value is or refers to N returns

A number

Value

A date, in one of the built-in date formats available in the software

The serial number of that date

TRUE

1

FALSE

0

An error value, such as #DIV/0!

The error value

Anything else

0

 

Remarks:

It is not generally necessary to use the N function in a formula, because the software automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.

The software stores dates as sequential serial numbers so they can be used in calculations. January 1, 1900 is serial number 1, and January 1, 2011 is serial number 40544 because it is 40,544 days after January 1, 1900. (See the NOW function.)

Example:

Suppose A1 contains "7", A2 contains "Even", A3 contains "TRUE", and A4 contains "4/17/2011".

 

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link