I want to calculate x^d where d is eiter a positive or negative number. I
thought that this could be accomplished with logarithms to the base 10. So if
d is say 3 then 3*logx= some number but here is the problem. How to convert
the result back into 8 whole number that is base 10. For example, if d is
positive and 3 and x is 2 then using a calculator: 2^3 = 3log2=3*.301029
=.903089 then the anti log of .903089 = 8. I can't find the antilog function
in the 2000 Excel. If d is negative then this may be the only way to do it.
Thank you.
Hi. In cell A1, we can enter...
=3*LOG10(2)
to get your 0.90309
In another cell we can enter either of these...
=10^A1
=POWER(10,A1)
to get 8.
--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;CJquot; gt; wrote in message
...
gt;I want to calculate x^d where d is eiter a positive or negative number. I
gt; thought that this could be accomplished with logarithms to the base 10. So
gt; if
gt; d is say 3 then 3*logx= some number but here is the problem. How to
gt; convert
gt; the result back into 8 whole number that is base 10. For example, if d is
gt; positive and 3 and x is 2 then using a calculator: 2^3 = 3log2=3*.301029
gt; =.903089 then the anti log of .903089 = 8. I can't find the antilog
gt; function
gt; in the 2000 Excel. If d is negative then this may be the only way to do
gt; it.
gt; Thank you.
Very good, thank you.
quot;Dana DeLouisquot; wrote:
gt; Hi. In cell A1, we can enter...
gt;
gt; =3*LOG10(2)
gt; to get your 0.90309
gt;
gt; In another cell we can enter either of these...
gt; =10^A1
gt; =POWER(10,A1)
gt;
gt; to get 8.
gt; --
gt; HTH. :gt;)
gt; Dana DeLouis
gt; Windows XP, Office 2003
gt;
gt;
gt; quot;CJquot; gt; wrote in message
gt; ...
gt; gt;I want to calculate x^d where d is eiter a positive or negative number. I
gt; gt; thought that this could be accomplished with logarithms to the base 10. So
gt; gt; if
gt; gt; d is say 3 then 3*logx= some number but here is the problem. How to
gt; gt; convert
gt; gt; the result back into 8 whole number that is base 10. For example, if d is
gt; gt; positive and 3 and x is 2 then using a calculator: 2^3 = 3log2=3*.301029
gt; gt; =.903089 then the anti log of .903089 = 8. I can't find the antilog
gt; gt; function
gt; gt; in the 2000 Excel. If d is negative then this may be the only way to do
gt; gt; it.
gt; gt; Thank you.
gt;
gt;
gt;
- Nov 18 Sat 2006 20:10
exponentials
close
全站熱搜
留言列表
發表留言