Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do you use Excel 2007 to take the logarithm of a whole column of numbers?
I have a column of positive numbers and want to take the natural log of each. I know how to do this for each individual number... but how do you get Excel to do it for the entire column automatically?
Please give me the sequence of commands or steps in detail. Thanks in advance.
2 Answers
- IXL@XLLv 71 decade agoFavorite Answer
Your data in col A, In cell B1 enter
=IF(ISBLANK(A1),"",LN(A1))
Copy this cell, then select whole of col B, then CTRL+V
HTH
- kyllonenLv 44 years ago
Create yet another column. Say your expenditures are in column A1 - A100. In B1 form =A1*a million.02 spotlight down B thus far as you have information in column A. click on the Edit tab and choose Fill, Down. you ought to use any column to try this not in easy terms B.
