AntiLOG in Excel - does it exist!

  • Thread starter Thread starter Steen Kruse
  • Start date Start date
S

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
 
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)
 
Steen Kruse schreef in said:
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?
Click to expand...

=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 schreef in <194.109.133.29>:
=EXP(A1)
Click to expand...

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 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
Click to expand...

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.
 
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
 
Steen Kruse schreef in said:
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!
Click to expand...

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.
 
Back
Top