Hi There

Using Open Office Calc.
Doing a simple Calculation E.G =(E7*B5)+(E8*B5)+(E9*B5) etc..
I want the second cell in each parenthesis to stay at a constant value, however to do this i have to manually input it into each calculation, and i have thousands to do.

I can't use the drag command, as it increases both cells linearly by 1.

This is an example of what happens when i drag to replicate the calculation.
=(E7*B5)+(E8*B6)+(E9*B7) etc..
I need the second cell to remain constant in each parenthesis.

Any help on this at all would be appreciated.

Thanks for your time
 

---

Answer from Richard Rost:

Well, I've never used Open Office, so I don't know if this feature exists there, but I'd be surprised if it didn't in some form.

In Excel, you can use $ dollar signs to create an ABSOLUTE REFERENCE which causes a cell reference to NOT change as you copy/paste or Autofill it. For example:

=$A$1

That cell will always refer to A1.

See this tutorial for more help:

http://www.599cd.com/tips/excel/running-total/?key=BlFAlEx