| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I drag a formula so 1 variable changes and 1 stays on a cel
I want to make a formula that when dragged will have one variable that will
change as it comes down the page and one that will stay constantly refering to a given cell. |
|
#2
|
|||
|
|||
|
You want an absolute address. Precede the cell you want to stay constant
with a $ sign. That tells Excel not to change it. Or, if you want, F4 will do it for you. -- Regards, Fred Please reply to newsgroup, not e-mail "keithpt" wrote in message ... I want to make a formula that when dragged will have one variable that will change as it comes down the page and one that will stay constantly refering to a given cell. |
|
#3
|
|||
|
|||
|
You are AWSOME!! thank you for quickness and helpfulness!
"Fred Smith" wrote: You want an absolute address. Precede the cell you want to stay constant with a $ sign. That tells Excel not to change it. Or, if you want, F4 will do it for you. -- Regards, Fred Please reply to newsgroup, not e-mail "keithpt" wrote in message ... I want to make a formula that when dragged will have one variable that will change as it comes down the page and one that will stay constantly refering to a given cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
| Cannot drag content or formula to another cells | Excel Discussion (Misc queries) | |||
| How do i "drag" a formula? | New Users to Excel | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| How do I drag a formula from right to left columns instead of rig. | Excel Discussion (Misc queries) | |||
Linear Mode
