N

Converts data into a code number in Excel
Returns a value converted to a number

Rational

Converts data into a code number

Description

The Excel N function returns a code number by converting specific reference based on the rules given below. For example, =N(B6) will return 43093 where B6 refers to a date 24-12-2017.

Syntax

=N (value)

Parameters

value – The input to convert into numbers

Return Value

Number or error code

Key Notes

  • Use the N function to convert data into a number.
  • The N function is used rarely as Excel automatically converts values as necessary.
  • The N function is provided only for compatibility with other spreadsheet programs.

Values convert according to the following rules:

If value is or refers toN returns
A numberSame Number
Excel valid dateDate serial number format
TRUE1
FALSE0
An error valueSame error value
Any other value0

Keep Reading Similar Functions:

Check a cell for the numerical value in Excel

ISNUMBER

The ISNUMBER function checks if a specified cell has a numeric value and returns “TRUE” if a cell has a numeric value, and “FALSE” when a cell does not.

Read More »
Check a cell for even number in Excel

ISEVEN

The ISEVEN function checks if a cell has even numeric value and returns “TRUE” for even numeric value, & “FALSE” for an odd number.

Read More »
Check a cell for odd or even numerical value in Excel

ISODD

The ISODD function checks if a specified cell has an odd numeric value and returns “TRUE” when a cell has an odd numeric value and “FALSE” for an even number.

Read More »