Inverse or anti-logs.
Posted by Jon Ayres on November 15, 2001 2:52 AM
Is there a corresponding inverse or anti LOG function ?
Cheers,
Jon
Posted by dan on November 15, 2001 5:46 AM
My math is a bit rusty, but isn't inverse log of x = 10^x ?
So you can just use that. If you are trying to find the inverse log of a number in cell A1, then use
=10^A1
Let me know if I'm wrong. HTH
Posted by Joe Was on November 15, 2001 10:59 AM
The only standard inverse log function that I know of in Excel is LOGINV the log normal sum of the distribution of x.
LOGINV(probability[log normal distribution where P>0 or P<1], mean[of In(x)], standard_dev[SD of In(x) where SD>0])
The regular LOG function will allow for user defined powers and bases. Excel has an inaginary log function as well. The normal LOG function also has pre-defined base 2 and 10 forms. JSW
