If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Relative reference for a table formula
The following table formula does the calculation I need using 3 columns
and two rows: =E5+C6D6 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 
Ads 
#2




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+C6D6 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




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+C6D6 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




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

