Saturday, June 2, 2007

Calculating logarithm of a number in excel

The logarithm of any number can be calculated in excel using the formula function.

To do so go to "Insert" menu and select "Function" which has a "Fx" symbol. In the dialog box choose the math and trig functions. In Math and trig functions choose "log" function or "Log 10" function as need be.

A box asking for the number and its base appears. You can either enter the number directly or choose a box from which the number has to be taken. For choosing a box press the button at the right end of the input column asking for the number. After selecting the box you can come back to the main box by pressing the same box again. Press ok and you have got the results.