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.

2 comments:

Anonymous said...

Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!

Anonymous said...

Genial post and this fill someone in on helped me alot in my college assignement. Say thank you you on your information.