+ Reply to Thread
Results 1 to 3 of 3

exponentials

  1. #1
    CJ
    Guest

    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.

  2. #2
    Dana DeLouis
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    >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.




  3. #3
    CJ
    Guest

    Re: 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" <[email protected]> wrote in message
    > news:[email protected]...
    > >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.

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1