MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inverse or anti-logs.

Posted by Jon Ayres on November 15, 2001 2:52 AM

Is there a corresponding inverse or anti LOG function ?



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

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