# N

## 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.

=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 to N returns A number Same Number Excel valid date Date serial number format TRUE 1 FALSE 0 An error value Same error value Any other value 0

### 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.

### ISEVEN

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

### 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.