Antilog

[btahu]

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

 

[dk]

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?
_________________
<font face="Arial Black" color="#0000FF">Hope this helps,
DK</font>
This message was edited by dk on 2003-02-19 20:50

 

[bmwill]

- 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...
<link id="Main-File" rel="Main-File" href="file://localhost/Users/Berthepwr/Library/Caches/TemporaryItems/msoclip1/01/clip.htm"> <style> <!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:"\.";} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} --> </style> <table style="border-collapse: collapse; width: 78px; height: 17px;" border="0" cellpadding="0" cellspacing="0"> <col style="" width="53"> <tbody><tr height="12"> <!--StartFragment--> <td x:num="3.56224789026243E-13" align="right" height="12" width="53">
</td> <!--EndFragment--> </tr> </tbody></table>

 

[VoG]

Try

=10^A1

 

[bmwill]

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