Difference between revisions of "Manuals/calci/N"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''N(x)'''</div><br/> |
| + | *<math>x</math> is the value. | ||
| − | |||
| − | + | ==Description== | |
| − | + | *This functon gives converted value of a number. | |
| − | + | *In N(x),x is the value to convert in to a number. | |
| + | *The following values are converted in to a number: | ||
| + | X value N returns(Result) | ||
| + | A number The Same number | ||
| + | Any date in DATE The Serial number of that date | ||
| + | function format | ||
| + | TRUE 1 | ||
| + | FALSE 0 | ||
| + | An error value Error value | ||
| + | Anything else 0 | ||
| + | ==Examples== | ||
| + | #N(100)=100 | ||
| + | #N(-154)=-154 | ||
| + | #N(2/1/1987)=0.001006543 | ||
| + | #N(TRUE)=1 | ||
| + | #N(FALSE)=0 | ||
| + | #N(2/0)=Infinity | ||
| + | #N("10/4")=0 | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/T | T ]] | ||
| + | |||
| + | ==References== | ||
Examples | Examples | ||
Revision as of 03:15, 1 January 2014
N(x)
- is the value.
is the value.
Description
- This functon gives converted value of a number.
- In N(x),x is the value to convert in to a number.
- The following values are converted in to a number:
X value N returns(Result) A number The Same number Any date in DATE The Serial number of that date function format TRUE 1 FALSE 0 An error value Error value Anything else 0
Examples
- N(100)=100
- N(-154)=-154
- N(2/1/1987)=0.001006543
- N(TRUE)=1
- N(FALSE)=0
- N(2/0)=Infinity
- N("10/4")=0
See Also
References
Examples
''''''' ''''
Description
This function gives a value converted to a number.
N
N(V)
where V is the value which is to be converted.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 20 | 20 | word | 0 |
| Row2 | 10/31/2008 | Fri Oct 31 00:00:00 UTC+0530 2008 | ||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
Let's see an example in Column1Row1
Let B2 = 20,
I.e.=N(B2) is 20
Let D2 = word
I.e.=N(D2) is 0
Let B3 = 10/31/2008
I.e.=N(B3) is Fri Oct 31 00:00:00 UTC+0530 2008