| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying formulas in excel
I have the column A full with 252 entries. The formula I apply between cells
A2 and A1 is: ln(A2/A1) and I get a result. I want to copy this formula but in a way that the Excel itself to perform the following calculation: ln(A3/A2) ln(A4/A4) ln(A5/A4) etc. I would be pleased if someone could tell me if I can achieve that. -- antonis |
|
#2
|
|||
|
|||
|
Click on the first cell with a formula in it. A small black square should be at the bottom right corner of the outline of the cell. Click and drag this cell down; it should copy the formula the way you want. Szalapski -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=399915 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
| Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
| Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
Linear Mode
