AntiLOG in Excel - does it exist!

[Steen Kruse]

I was supprised to experience that the anti LOG10 does not exist, not even
as an INVERSE LOG10. I would like not to use the itteration solver.Can
anybody help me?

Kind regards
Steen Kruse

 

[Bernard Liengme]

The definition of Log (to base ten) is:
If y = 10^x, then we say Log(y)=x
So the inverse is y=10^x

Example log(100) =2
Antilog of 2 is 10^2 which is 100

So you find the antilog of x with 10^x
The antiln of x (log to base e) with exp(x)

 

[Amedee Van Gasse]

I was supprised to experience that the anti LOG10 does not exist, not
even as an INVERSE LOG10. I would like not to use the itteration
solver.Can anybody help me?

=EXP(A1)

--
Amedee Van Gasse
http://www.amedee.be

To top-post is human, to bottom-post and snip is sublime.

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[Amedee Van Gasse]

Amedee Van Gasse schreef in <194.109.133.29>:

=EXP(A1)

Sorry, EXP is the inverse of LN (base e)
For the inverse of LOG (base 10) you need =10^A1

--
Amedee Van Gasse
http://www.amedee.be

To top-post is human, to bottom-post and snip is sublime.

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[Amedee Van Gasse]

Amedee Van Gasse schreef in <194.109.133.29>:

Sorry, EXP is the inverse of LN (base e)
For the inverse of LOG (base 10) you need =10^A1

By the way:
inv ln(x) = exp(x) = e^x = 2.71828182845904^x
inv log(x) = 10^x

You can use the same math for any log base like log2 or log1024 or
whatever.

--
Amedee Van Gasse
http://www.amedee.be

To top-post is human, to bottom-post and snip is sublime.

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[Steen Kruse]

Thank you for your fast replies. I'm still surprised that the function
"ALOG10" does not exist while a lot of other inverse functions and some
weird functions are available thou. Not all Microsoft Excel users are
mathematical rounded. But of cause by time they will!

Best regards
Steen Kruse

"Amedee Van Gasse"
<nzrqrr.qvgzntjrt.ina.tnffr.qvgzntbbxjrt@orfgnngavrg.rztebhc.qbabgfcnz.or>
skrev i en meddelelse

 

[Amedee Van Gasse]

Thank you for your fast replies. I'm still surprised that the function
"ALOG10" does not exist while a lot of other inverse functions and
some weird functions are available thou. Not all Microsoft Excel users
are mathematical rounded. But of cause by time they will!

Weeeellll... there *is* an inverse of LOG and that is ^
Having another function would be a bit redundant. Anyway if you're using
the LOG function, you are already a bit mathematical rounded...

If you really, really want to dig deep into maths, check out a product
like Mathcad! Compared to that, Excel is no more than an abacus!

--
Amedee Van Gasse
http://www.amedee.be

To top-post is human, to bottom-post and snip is sublime.

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.