Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − Syntax+ + + + + + + + − </div></div>+ − ---- − <div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify"> − Remarks+ + + + + + − </div></div>+ − ----+ − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">+ + − Examples − </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 calculates the common logarithm (base 10) of a complex number in a + bi or a + bj text format.</font></font></font> − − </div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6">'''<font face="Arial">IMLOG10</font>'''</font></div></div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − * <font color="#484848"><font face="Arial, sans-serif"><font size="2">The common logarithm of a complex number can be calculated from the natural logarithm as follows: </font></font></font> − − <font color="#484848">log<sub>10</sub>(x+yi)=(log<sub>10</sub>e)1n(x+yi)</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">'''IMLOG10'''</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 a complex number </font></font></font> − − </div></div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"> − − {| id="TABLE1" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f" | 0.7311989989494778+0.16525181990889784i − | 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="7SpaceContent" 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. =IMLOG10(“5+2i”) is 0.73119+0.16525i</font></font></font> − − </div> − ----
Manuals/calci/IMLOG10 (view source)
Revision as of 09:21, 16 December 2013
, 09:21, 16 December 2013no edit summary
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<div style="font-size:30px">'''IMLOG10(z)'''</div><br/>
*<math>z</math> is the complex number is of the form <math>x+iy</math>
==Description==
*This function gives the common logarithm of a complex number.
*IMLOG10(z),Where z is the complex number in the form of "x+iy".i.e. x&y are the real numbers.
*'I' imaginary unit .i=sqrt(-1).
*Log base 10, is known as the common logarithm or decadic logarithm, is the logarithm to the base 10.
*To find the common logarithm of a complex number we have to calculate from the natural logarithm.
*So log10(x+iy)=(log10 e)ln(x+iy).
*We can use COMPLEX function to convert real and imaginary number in to a complex number.
==Examples==
#IMLOG10("6+7i")=0.964709462857146+0.37443569720420i
#IMLOG10("4-5i")=0.806391928359868-0.389151908999031i
#IMLOG10("8")=0.903089986991944
#IMLOG10("3i")=0.477121254719662+0.682188176920921i
#IMLOG10("0")=NULL
*Imln("8") for that it should consider the imaginary value is zero,but calci is not considering like EXCEL
==See Also==
*[[Manuals/calci/IMLN | IMLN ]]
*[[Manuals/calci/LOG10 | LOG10 ]]
*[[Manuals/calci/COMPLEX | COMPLEX ]]
==References==
[http://en.wikipedia.org/wiki/Bessel_function Bessel Function]