# Antilog

This is a discussion on Antilog within the Excel Questions forums, part of the Question Forums category; How do you do, or use antilog in excel. The log function is Ok....

1. How do you do, or use antilog in excel. The log function is Ok.

2. As far as I know, Excel has no AntiLog function. However, it's just a simple calculation:-

Assuming base 10, the antilog of x is 10^x

e.g.

LOG10(100)=2

Antilog 2= 10^2 = 100

Does that make sense?
_________________
Hope this helps,
DK

[ This Message was edited by: dk on 2003-02-19 20:50 ]

3. ## Re: Antilog

- but how do you make excel calculate the antilog of a number in a cell? A calculated number? What is the syntax? The caret does not seem to work?

- Sorry - it does! =10^(-(19,9+J4)/3,48) (with J4 =23,4) returns 3,56224789026243E-13 - which at least is the right order of magnitude...

Try

=10^A1

5. ## Re: Antilog

Thanks Peter
- fast response even if I did figure out to do it proper myself!

#### Posting Permissions

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