[vjk]

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

[Doug Robbins - Word MVP]

See fellow MVP Macropod's Word Field Maths Tutorial at:

http://lounge.windowssecrets.com/ind...owtopic=365442

or at:

http://www.gmayor.com/downloads.htm#Third_party

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"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

[macropod[_2_]]

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

[vjk]

On 2010.03.29 19:44, vjk wrote:
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

Quite apparent that Word does not do that. WordFieldMaths was quite
enlightening.

TYVM