N Function Dictionary

Function Dictionary Function Examples Function Categories

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.
No special formatting is needed.


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download