1. Lounger - I've started doing some statistical training that involved logs and antilogs

I have found the log calculaton but not sure where or how to calculate antilogs

Still new at this, but of anyone has any ideas would be please to get some advise

2. Working with a number A and to the base B:

Log A to the base B is =LOG(B,A)

Antilog A to the base B is =B^A

If you omit the base argument of the log function, you get the base 10 logarithm. For example =LOG(1000) will return 3.
The inverse of this is =10^... or =POWER(10,...)

Mathematicians often use logarithms with base e ~ 2.71828.
There is a special function for this: LN, with inverse EXP.

So =LN(45) is equivalent to =LOG(45,e) and =EXP(3) is equivalent to =e^3.

Following on from your info - (I haven't had to do this for a long time and when I did it was'nt using excel)

In A1 i have 2, in B2 I have =Log(A1,10) giving the result 0.301029996

To Antilog A1 (2) in say B3, what formula would I use (is the ^ on shift 6 the correct symbol?)

Thank for any assistance

To Antilog A1 (2) in say B3, what formula would I use (is the ^ on shift 6 the correct symbol?)
You can use either

=10^A1

where ^ is Shift+6, or

=POWER(10,A1)

#### Posting Permissions

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