The definition of log (base 10) is:
If x = 10^y then we say LOG(x) =y
Example: 100 = 10^2 so LOG(100)=2
It follows that if I know y and want x I use x = 10^y
If I know the log of x is 2, then x = 10^2 = 100
The definition of LN (base e) is:
If x = e^y (which can also be written as x=EXP(y)) then we say LN(x) =y
Example: 3 = e^1.096 so LOG(3)=1.096
It follows that if I know y and want x I use x = e^y
If I know LN(x) = 1.096 then x = EXP(1.906) which works out to be 3
If A1 contains the result of your LOG10 formula (e.g., =LOG10(1.234)),
then the antilog is =10^A1.
Although that does return exactly 1.234 in that case, in general do
not expect the antilog to exactly equal the parameter of LOG10. For
example, if A1 is =LOG10(PI()), =10^A1-PI()=0 is FALSE(!) .
Also, do not expect the antilog to exactly match mathematical
equalities. For example, if A1 is =LOG10(4.5)+LOG10(2) , =10^A1=9
Infinitesimal differences are due to the limitations of computer
arithmetic as well as to the fact that generally LOG10 and the power
operator (^) use generating functions or algorithms to approximate
their results (when the exponent is non-integer in the case of the
 But =10^A1=PI() is TRUE. The difference is due to Excel
heuristics which try to hide inequalities when the difference is
"close" to zero.
 We expect LOG10(4.5)+LOG10(2) = LOG10(4.5*2) = LOG10(9) based on
PS: For broader participation, you might want to post future
inquiries using the MS Answers Forums at http://social.answers.microsoft.com/Forums/en-US/category/officeexcel.
It's not that I like that forum. It's just that MS has ceased to
support the Usenet newsgroups. Hence, participation here is limited
to the sites that share a common newsgroup mirror, which is no longer
centralized at MS.