ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   exponentials (https://www.excelbanter.com/excel-worksheet-functions/83448-exponentials.html)

CJ

exponentials
 
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.

Dana DeLouis

exponentials
 
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. :)
Dana DeLouis
Windows XP, Office 2003


"CJ" wrote in message
...
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.




CJ

exponentials
 
Very good, thank you.

"Dana DeLouis" wrote:

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. :)
Dana DeLouis
Windows XP, Office 2003


"CJ" wrote in message
...
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.






All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com