View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Thank everyone for suggestions

Thank everyone for suggestions
Eric

"Dave Peterson" wrote:

Or use some algebra:

=Power(2,a)
is the same as
2^a (2 raised to the power of a

The equality to start
2^a = 1
taking the natural log of both sides:
ln(2^a) = ln(1)
the left hand side becomes: a*ln(2)
the right hand side becomes 0
so
a*ln(2) = 0
divide both sides by ln(2)
a = 0/ln(2)
or
a = 0

=====
So if you had
=power(2,a) = x
you could do the same thing
2^a = 1
taking the natural log of both sides:
ln(2^a) = ln(x)
the left hand side becomes: a*ln(2)
so
a*ln(2) = ln(x)
divide both sides by ln(2)
a = ln(x)/ln(2)



Eric wrote:

Power(2,a) = 1,
Does anyone have any suggestions on how to determine the value of a?
Thank for any suggestions
Eric


--

Dave Peterson