you could also do this:
pick a random cell that isnt part of your main table, and make that value equal to 1000 (for example let's say Z1)
then, for your formula, instead of going =1000-A1, =1000-B1, etc you can do this
(=$Z$1-A$1)
Then just drag the formula down and then to the right.
|