| Line 1: |
Line 1: |
| − | <div id=" 16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | + | <div style="font-size:30px">'''IMREAL(z)'''</div><br/> |
| | + | *<math>>z</math is the complex number is of the form <math>x+iy</math> |
| | | | |
| − | Syntax
| |
| | | | |
| − | </div></div>
| + | ==Description== |
| − | ----
| + | *This function gives the real coefficient of the complex number. |
| − | <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
| + | *MREAL(z), Where z is the complex number is in the form of "x+iy".i.e. |
| | + | *x&y are the real numbers.'i' imaginary unit .i=sqrt(-1). |
| | + | *The complex number z= x+iy can be identified by (x,y) in the complex plane. |
| | + | *Here x is called real part and y is the imaginary part of z. |
| | + | *This function shows the value of the real part of z. |
| | + | *A complex is said to be purely imaginary when x=0 and it is a real number when y=0. |
| | + | *We can use COMPLEX function to convert real and imaginary number in to a complex number. |
| | | | |
| − | Examples | + | ==Examples== |
| | | | |
| − | </div></div>
| + | #IMREAL("3+4i")=3 |
| − | ----
| + | #IMREAL("-5+6i")=-5 |
| − | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
| + | #IMREAL("8")=8 |
| − | ----
| + | #IMREAL("-2i")=0 |
| − | <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
| |
| | | | |
| − | <font size="5">Description</font>
| |
| | | | |
| − | </div></div>
| + | ==See Also== |
| − | ----
| + | *[[Manuals/calci/IMSUB | IMSUB ]] |
| − | <div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| + | *[[Manuals/calci/IMSUM | IMSUM ]] |
| | + | *[[Manuals/calci/IMAGINARY | IMAGINARY ]] |
| | + | *[[Manuals/calci/COMPLEX | COMPLEX ]] |
| | | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">This function calculates the real coefficient of a complex number in a+ bi or a + bj text format.</font></font></font>
| |
| | | | |
| − | </div></div>
| + | ==References== |
| − | ----
| + | [http://en.wikipedia.org/wiki/Binary_logarithm Binary Logarithm] |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">IMREAL</font></div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''IMREAL'''</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">'''IN'''</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 IN</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the complex number.</font></font></font>
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" 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=" " |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="f52543 " |
| |
| − | | class="SelectTD" |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example.</font></font></font>
| |
| − | | |
| − | <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e =IMREAL(“20-13i”) is 20</font></font></font>
| |
| − | | |
| − | <br /><br />
| |
| − | | |
| − | </div>
| |
| − | ----
| |