.

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