Learn how to use the Excel N function with syntax and examples.
What Does It Do?
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.
No comments:
Post a Comment