| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Copy a formula maintaining a constant cell
I'm wanting to copy a formula down a list of cells i.e. =SUM(G7*100)/G101
updating the first cell (G7) to the next (G8) and so on while keeping G101 constant throughout. I seem to recall the use of the $ sign but it's slipped my mind how to do it. |
|
#2
|
|||
|
|||
|
put your cursor in front of the G101 and press the <F4 key
"Tiana" wrote: I'm wanting to copy a formula down a list of cells i.e. =SUM(G7*100)/G101 updating the first cell (G7) to the next (G8) and so on while keeping G101 constant throughout. I seem to recall the use of the $ sign but it's slipped my mind how to do it. |
|
#3
|
|||
|
|||
|
Thank you!
"lk" wrote: put your cursor in front of the G101 and press the <F4 key "Tiana" wrote: I'm wanting to copy a formula down a list of cells i.e. =SUM(G7*100)/G101 updating the first cell (G7) to the next (G8) and so on while keeping G101 constant throughout. I seem to recall the use of the $ sign but it's slipped my mind how to do it. |
|
#4
|
|||
|
|||
|
Try
=G7*100/$G$101 The SUM() is superfluous. In article , "Tiana" wrote: I'm wanting to copy a formula down a list of cells i.e. =SUM(G7*100)/G101 updating the first cell (G7) to the next (G8) and so on while keeping G101 constant throughout. I seem to recall the use of the $ sign but it's slipped my mind how to do it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Copy cell formula help | Excel Discussion (Misc queries) | |||
| How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| copy contains from cell to cell w/ formula | Excel Worksheet Functions | |||
Hybrid Mode
