Rgds< 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...