| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I reference the same cell as I move through range of cells.
I want to refence the same cell as I copy the initial range of cells further
down the page. Two of the cells referenced in the formula need to change, but I need one to stay constant: =IF(AND(C4C121, C5C122), 500, "n/a") C4 and C5 need to change as I copy to new areas, but C121 and C122 need to be constantly referenced. |
|
#2
|
|||
|
|||
|
are you thinking of absolute reference
for .e.g $c$121 and $c$122 MikeShep wrote in message ... I want to refence the same cell as I copy the initial range of cells further down the page. Two of the cells referenced in the formula need to change, but I need one to stay constant: =IF(AND(C4C121, C5C122), 500, "n/a") C4 and C5 need to change as I copy to new areas, but C121 and C122 need to be constantly referenced. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Linear Mode
