.

N Function Dictionary

Function Dictionary Function Examples Function Categories

N              
 
 
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.

.

Popular posts from this blog

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

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download