N Function in Excel with Example

N ()

This function converts a numeric entry to its mathematical value.

Anything which will not convert is shown as 0 zero. Excel does not really need this function, due to the fact that Excel calculates in this way naturally. The function is included for compatibility with other spreadsheet programs.

 Best view in desktop mode.

	A	B	C	D
1	Original Value	Converted Value
2	1	1	=N(A2)
3	4 1/2	4.5	=N(A3)
4	7.5	7.5	=N(A4)
5	6.50%	0.065	=N(A5)
6	3-Mar-20	43893	=N(A6)
7	TRUE	1	=N(A7)
8	FALSE	0	=N(A8)
9	Hello Dear	0	=N(A9)
10		0	=N(A10)
11

Syntax

=N(value)

Formatting

No special formatting is needed.

ROUND in Excel

<<  Previous

Next  >>

NA in Excel