|
|
(15 intermediate revisions by 2 users not shown) |
Line 1: |
Line 1: |
− | <div style="font-size:30px">'''N(x)'''</div><br/> | + | <div style="font-size:30px">'''N(Number)'''</div><br/> |
− | *<math>x</math> is the value. | + | *<math>Number</math> is the value. |
− | | |
| | | |
| ==Description== | | ==Description== |
− | *This functon gives converted value of a number. | + | *This function gives converted value of a number. |
− | *In <math> N(x),x</math> is the value to convert in to a number. | + | *In <math> N(Number)</math>, <math>Number</math> is the value to convert in to a number. |
| *The following values are converted in to a number: | | *The following values are converted in to a number: |
− | X value N returns(Result)
| + | ''' value''' '''N returns(Result)''' |
− | #A number The Same number
| + | A number - The Same number |
− | #Any date in DATE The Serial number of that date
| + | Any date in DATE function format - The Serial number of that date |
− | function format
| + | TRUE - 1 |
− | #TRUE 1
| + | FALSE - 0 |
− | #FALSE 0
| + | An error value - Error value |
− | #An error value Error value
| + | Anything else - 0 |
− | #Anything else 0
| + | |
| + | |
| + | ==ZOS== |
| + | *The syntax is to converting in to a number in ZOS is <math>N(Number)</math> |
| + | **<math>Number</math> is the value. |
| + | *For e.g.,N(29/5/2014),N(15*4+10-2/12) |
| | | |
| ==Examples== | | ==Examples== |
− | #N(100)=100 | + | #=N(100) = 100 |
− | #N(-154)=-154 | + | #=N(-154) = -154 |
− | #N(2/1/1987)=0.001006543 | + | #=N(2/1/1987) = 0.001006543 |
− | #N(TRUE)=1 | + | #=N(TRUE) = 1 |
− | #N(FALSE)=0 | + | #=N(FALSE) = 0 |
− | #N(2/0)=Infinity | + | #=N(2/0) = Infinity |
− | #N("10/4")=0 | + | #=N("10/4") = 0 |
| + | |
| + | ==Related Videos== |
| + | |
| + | {{#ev:youtube|JUB0E5r_ERw|280|center|N}} |
| | | |
| ==See Also== | | ==See Also== |
Line 29: |
Line 37: |
| | | |
| ==References== | | ==References== |
− | Examples
| + | *[http://www.techonthenet.com/excel/formulas/n.php Converts a value to a number]. |
− | | |
− | </div></div>
| |
− | ----
| |
− | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
| |
− | ----
| |
− | <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
| |
− | | |
− | <font size="5">Description</font>
| |
− | | |
− | </div></div>
| |
− | ----
| |
− | <div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function gives a value converted to a number.</font></font></font>
| |
− | | |
− | </div></div>
| |
− | ----
| |
− | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">N</font></div></div>
| |
− | ----
| |
− | <div id="6SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''N'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''V'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">where V</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the value which is to be converted. </font></font></font>
| |
− | | |
− | </div></div>
| |
− | ----
| |
− | <div id="1SpaceContent" class="zcontent" align="left">
| |
− | | |
− | {| id="TABLE3" class="SpreadSheet blue"
| |
− | |- class="even"
| |
− | | class=" " |
| |
− | | Column1
| |
− | | Column2
| |
− | | Column3
| |
− | | Column4
| |
− | |- class="odd"
| |
− | | class=" " | Row1
| |
− | | class="sshl_f " | 20
| |
− | | class="sshl_f" | 20
| |
− | | class="sshl_f " | word
| |
− | | class="sshl_f" | 0
| |
− | |- class="even"
| |
− | | class=" " | Row2
| |
− | | class="sshl_f " | 10/31/2008
| |
− | | class="sshl_f" | Fri Oct 31 00:00:00 UTC+0530 2008
| |
− | | class=" " |
| |
− | | class=" sshl_f " |
| |
− | |- class="odd"
| |
− | | Row3
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" sshl_f SelectTD" |
| |
− | <div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
− | | class=" sshl_f" |
| |
− | |- class="even"
| |
− | | Row4
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | |- class="odd"
| |
− | | class=" " | Row5
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | |- class="even"
| |
− | | Row6
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | | class=" " |
| |
− | |}
| |
− | | |
− | <div align="left">[[Image:calci1.gif]]</div></div>
| |
− | ----
| |
− | <div id="4SpaceContent" class="zcontent" align="left">
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example in Column1Row1</font></font></font>
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let B2 = 20,</font></font></font>
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=N(B2) is 20</font></font></font>
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let D2 = word</font></font></font>
| |
− | | |
− | <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=N(D2) is 0</font></font></font>
| |
− | | |
− | <font color="#666666"><font face="Arial, sans-serif"><font size="2">Let B3 = 10/31/2008</font></font></font>
| |
− | | |
− | <font color="#666666"><font face="Arial, sans-serif"><font size="2">I.e.=N(B3) is Fri Oct 31 00:00:00 UTC+0530 2008</font></font></font>
| |
− | | |
− | <br />
| |
− | | |
− | <br />
| |
− | | |
− | </div>
| |
− | ----
| |