logarithms back to numbers in Excel?
 

How do I convert logarithms back to numbers in Excel. Log base 10 and natural.

logarithms back to numbers in Excel?
 

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

Likewise:
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

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Polly" wrote in message
...
How do I convert logarithms back to numbers in Excel. Log base 10 and
natural.

logarithms back to numbers in Excel?
 

Very helpful, thank you Bernard. But is there a function in Excel that I can
use for a column of many figures?


Kind regards
Polly

"Bernard Liengme" wrote:

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

Likewise:
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

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Polly" wrote in message
...
How do I convert logarithms back to numbers in Excel. Log base 10 and
natural.

logarithms back to numbers in Excel?
 

=10^A1 or =POWER(10,A1)
=EXP(A1)
--
David Biddulph

"Polly" wrote in message
...
How do I convert logarithms back to numbers in Excel. Log base 10 and
natural.

logarithms back to numbers in Excel?
 

Tue, 22 May 2007 06:46:01 -0700 from Polly
:
How do I convert logarithms back to numbers in Excel. Log base 10
and natural.

=10^A1

=EXP(A1)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/