AntiLog function

[Tony Burke]

I need the antilog of a number; is there such a feature in Excel?
I can find LOG but not the antilog.

Rgds< Tony

[Chip Pearson]

Tony,

The LOG function returns a base-10 logarithm. Therefore, the inverse function
is simply raising the 10 to that power. E.g.,

=10^B1

If you are using the LOG function to get the log in an arbitrary base, such as

=LOG(A1,B1)
raise the base in B1 to the LOG result. E.g.,
=B1^C1

If you are using the LN function to get the base-e log, use EXP to do the
inverse. E.g.,

=EXP(B2)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"Tony Burke" <to...@burket96.fsnet.co.uk> wrote in message
news:a8pkpp$3vl$1...@newsg3.svr.pol.co.uk...

[KRCowen]

You can use 10^x to find the number of which x is the LOG, if that is what you
want. Use exp(1)^x for LN.
Good luck.
Ken