Hi vjk,
Word doesn't provide any native support for relative cell addressing. Depending on what exactly you need to do, you might be able to
incorporate a SUM(LEFT) function (eg =SUM(ABOVE)+SUM(LEFT)). Alternatively, for a workaround and details of how to do a wide range
of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party
--
Cheers
macropod
[Microsoft MVP - Word]
"vjk" wrote in message ...
The following table formula does the calculation I need using 3 columns
and two rows:
=E5+C6-D6
For keeping a record of payments...
E is the running balance, C is the current debit and D is the current credit
How do I turn that into a relative reference so it can be added without
changes to each row
I presume it starts with =SUM(ABOVE)+ ? - ?
TIA