Hello,

How can I divide a logarithm by a logarithm? For example, I would like to
make the following computation in one cell:

= log10(number) / log10(number)

I know I can take the log of the numerator in one cell and the denominator
in another, however, this is not what I want. Please advise

=LOG10(A1)/LOG10(A2)

Tim

--
Tim Williams
Palo Alto, CA


"sirsoto" wrote in message
...
Hello,

How can I divide a logarithm by a logarithm? For example, I would like to
make the following computation in one cell:

= log10(number) / log10(number)

I know I can take the log of the numerator in one cell and the denominator
in another, however, this is not what I want. Please advise

If by Log10(number) you mean Log (number) to base 10, then

=Log(A1)/Log(B1) in your chosen cell.


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=388201

Thanks for responding. I tried it but it didn't work. In cell A1, I typed
the following:

=log( ( ((300000*.05)+1) / (150*49) ) /log(1.05) )

i only put the spaces here for your ease of reading. The result should
equal a non-integer, 22.0918475.

I did it by hand, so i know this value is correct.

Did Excel give you an answer of about 0.027?

I tried it by hand and got around 0.027. I copied and pasted what yo
wrote without the spaces into Excel and got around 1.98. I entered th
different sets of the problem individually into Excel and got th
correct answer of 0.027 again

--
Loss
-----------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...fo&userid=2481
View this thread: http://www.excelforum.com/showthread.php?threadid=38820

Excel knows the correct order of operations. As soon as you close the
)'s, the log entry is complete.
You can try:
=LOG(1+300000*0.05)/(150*49) /LOG(1.05)

to get the correct answer of around 0.27


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=388201

here in Excel what are logarithms for? what specific jobs could this be
applicable to? thanx

l.a.: logarithms show up frequently in math, science, and engineering
calculations. Basically, a logarithm is the "inverse" of
exponentiation [10^3=1000, log10(1000)=3]. There are several good
tutorials on logarithms on the internet - try putting "logarithm" into
your favorite search engine.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=388201