Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
vjk vjk is offline
external usenet poster
 
Posts: 2
Default Relative reference for a table formula

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
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Relative reference for a table formula

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


  #3   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Relative reference for a table formula

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


  #4   Report Post  
Posted to microsoft.public.word.tables
vjk vjk is offline
external usenet poster
 
Posts: 2
Default Relative reference for a table formula

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
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
identify table with bookmark to reference in formula Athena[_3_] Tables 1 January 25th 10 04:04 AM
Table Formula Jseakin Tables 3 April 23rd 09 10:44 PM
Word 2007 Master/Subdocumnet Relative Reference [email protected] New Users 1 February 17th 09 04:40 PM
Freeze the position of a table relative to the page and not the te womprat78 Page Layout 1 September 4th 08 06:57 PM
Table Position on page relative to footer Stephan Laska Tables 4 August 24th 06 02:15 PM


All times are GMT +1. The time now is 10:43 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"