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.

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.

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.