| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Same Value In Multiple Cells
Its been a while since I've used Excel and can't remember how you keep a
value constant in a part of a formula while changing another part of the formula? Example: =SUM(d2/d9) d9 will stay constant, but the d2 value will change as the formula is pasted into other cells. |
|
#2
|
|||
|
|||
|
Take a look at "The difference between relative and absolute references"
in XL Help. =SUM(D2/$D$9) In article , "kwelp" wrote: Its been a while since I've used Excel and can't remember how you keep a value constant in a part of a formula while changing another part of the formula? Example: =SUM(d2/d9) d9 will stay constant, but the d2 value will change as the formula is pasted into other cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| selecting multiple cells with ctrl key | Charts and Charting in Excel | |||
| Ctrl+V pasting to multiple non-adjacent cells | Excel Discussion (Misc queries) | |||
| Excel 97 - Selecting multiple cells from 2 different Pivot Tables | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
