Logarithms

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" <sirsoto@discussions.microsoft.com> wrote in message
news:1E3D7625-AED4-485C-8A80-50EA91E55DAE@microsoft.com...
> 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.

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.

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

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.