| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying functions from one cell to other cells
Thanks, that did the trick
"Niek Otten" wrote: =IF(I22M$20-1,-M$20,IF(J22M$21-1,M$21,N22)) -- Kind regards, Niek Otten "aaronwexler" wrote in message ... I have a question I was hoping someone could help me answer. I have the function =IF(I22M20-1,-M20,IF(J22M21-1,M21,N22)) in cell M22. Now I would like to find a quick way to copy this to cells M23,M24,M25.....and beyond. The problem is I want the some of the function to change when I copy it and some of it to stay the same. I would like the parts "M20-1,-M20" and "M21-1,M21" to stay the same while the other move down with each cell. For example in cell M23 (the next cell down in my range) I would like the function to read =IF(I23M20-1,-M20,IF(J23M21-1,M21,N23)). When I try and copy the cell using the drag and drop in the lower right corner of the cell it moves all cells in the function down one which is what I want except for the two parts I mentioned above. If there anyway to lock those two parts into place so I can drag and drop without moving those parts of the function down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| zero value when copying cells between worksheets | Excel Discussion (Misc queries) | |||
| Multiple "IF" functions one one cell returned from different cells | New Users to Excel | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
