31
Jan
Jan
Need excel formula for calculating the column c = log(100/column b)
Answer:
in box C2 type:
=Log(100/B2,10)
the 10 means log base 10.
copy and paste as far down as need it, making sure B3 is row 3 and so on. Excel should take care of this automatically.
Answer:
You almost have it. In cell C2 type:
=log(100/B2,10)
Then enter a number in B2 and it calculates your forumula using Base 10 (that's the ",10" at the end of the formula)
Returns the logarithm of a number to the base you specify
LOG(number,base)
Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList
This entry was posted
on Thursday, January 31st, 2008 at 4:08 pm and is filed under Software.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or TrackBack URI from your own site.