N Function (Functions in Excel)
Original | Converted | |
1 | 1 | =N(C4) |
3 1/2 | 3.5 | =N(C5) |
3.5 | 3.5 | =N(C6) |
3.50% | 0.035 | =N(C7) |
25-Dec-98 | 36154 | =N(C8) |
TRUE | 1 | =N(C9) |
FALSE | 0 | =N(C10) |
Hello | 0 | =N(C11) |
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. |
0 comments:
Post a Comment