Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 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 »
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 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 »