On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Thursday, May 22, 2014

N Function in MS-Excel

Learn how to use the Excel N function with syntax and examples.

C
D
3
Original
Converted
4
1
1
 =N(C4)
5
3 1/2
3.5
 =N(C5)
6
3.5
3.5
 =N(C6)
7
3.50%
0.035
 =N(C7)
8
25-Dec-98
36154
 =N(C8)
9
TRUE
1
 =N(C9)
10
FALSE
0
 =N(C10)
11
Hello
0
 =N(C11)
12

0
 =N(C12)


What Does It Do?
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.

Syntax
=N(NumericEntry)

Formatting
No special formatting is needed.