Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

AntiLog function

266 views
Skip to first unread message

Tony Burke

unread,
Apr 7, 2002, 10:22:56 AM4/7/02
to
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

unread,
Apr 7, 2002, 10:34:59 AM4/7/02
to
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

unread,
Apr 7, 2002, 10:52:21 AM4/7/02
to
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
0 new messages