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




Subtract formula
I know that the formula for adding fields is such as "sum(c23,c24)", but how
do I subtract one field from another? 
Ads  
#2




Candace was telling us:
Candace nous racontait que : I know that the formula for adding fields is such as "sum(c23,c24)", but how do I subtract one field from another? You can use SUM to add the negative of the second number: {=SUM(C23,{=(C24)})} Or, without SUM: {=(C23C24)} !!!  Salut! _______________________________________ JeanGuy Marcil  Word MVP ISTOO Word MVP site: http://www.word.mvps.org 
#3




I'm receiving syntax errors when I try to use the formula {=SUM(C23,{=(C24)})}
What could I be doing wrong? Is there a microsoft article I can refer to for more information on subtracting in Word tables? "JeanGuy Marcil" wrote: Candace was telling us: Candace nous racontait que : I know that the formula for adding fields is such as "sum(c23,c24)", but how do I subtract one field from another? You can use SUM to add the negative of the second number: {=SUM(C23,{=(C24)})} Or, without SUM: {=(C23C24)} !!!  Salut! _______________________________________ JeanGuy Marcil  Word MVP ISTOO Word MVP site: http://www.word.mvps.org 
#4




Nevermind. It worked fine when I used your {=(C23C24)} suggestion, but
without the braces. Thanks so much!!! "Candace" wrote: I'm receiving syntax errors when I try to use the formula {=SUM(C23,{=(C24)})} What could I be doing wrong? Is there a microsoft article I can refer to for more information on subtracting in Word tables? "JeanGuy Marcil" wrote: Candace was telling us: Candace nous racontait que : I know that the formula for adding fields is such as "sum(c23,c24)", but how do I subtract one field from another? You can use SUM to add the negative of the second number: {=SUM(C23,{=(C24)})} Or, without SUM: {=(C23C24)} !!!  Salut! _______________________________________ JeanGuy Marcil  Word MVP ISTOO Word MVP site: http://www.word.mvps.org 
#5




When you enter a formula in the Table  Formula dialog, you don't need the
braces. JeanGuy was quoting the field as a field, assuming you would be constructing it by hand (using Ctrl+F9 to insert the field delimiters, which are represented by the braces).  Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all followups to the newsgroup so all may benefit. "Candace" wrote in message ... Nevermind. It worked fine when I used your {=(C23C24)} suggestion, but without the braces. Thanks so much!!! "Candace" wrote: I'm receiving syntax errors when I try to use the formula {=SUM(C23,{=(C24)})} What could I be doing wrong? Is there a microsoft article I can refer to for more information on subtracting in Word tables? "JeanGuy Marcil" wrote: Candace was telling us: Candace nous racontait que : I know that the formula for adding fields is such as "sum(c23,c24)", but how do I subtract one field from another? You can use SUM to add the negative of the second number: {=SUM(C23,{=(C24)})} Or, without SUM: {=(C23C24)} !!!  Salut! _______________________________________ JeanGuy Marcil  Word MVP ISTOO Word MVP site: http://www.word.mvps.org 
#6




Suzanne S. Barnhill was telling us:
Suzanne S. Barnhill nous racontait que : When you enter a formula in the Table  Formula dialog, you don't need the braces. JeanGuy was quoting the field as a field, assuming you would be constructing it by hand (using Ctrl+F9 to insert the field delimiters, which are represented by the braces). My bad! I should have been more explicit! Thanks.  Salut! _______________________________________ JeanGuy Marcil  Word MVP ISTOO Word MVP site: http://www.word.mvps.org 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Formula to Sum values in word table  Craig  Mailmerge  1  August 29th 05 06:19 PM 
Printing data only and include formula from table  rhett203  Microsoft Word Help  0  August 8th 05 04:57 PM 
How can I subtract 2 columns in a table?  Becky  Tables  2  April 23rd 05 03:20 AM 
I need a formula of amount of hours from two times in two cell?  dmvargas29  Tables  2  November 20th 04 03:48 AM 
Formula in table  Creating a final total from subtotal cells  Anne Gilmour  Tables  1  November 7th 04 05:14 AM 