View Single Post
  #5   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

When you enter a formula in the Table | Formula dialog, you don't need the
braces. Jean-Guy 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 follow-ups to the newsgroup so
all may benefit.

"Candace" wrote in message
...
Never-mind. It worked fine when I used your {=(C23-C24)} 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?

"Jean-Guy 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:

{=(C23-C24)}

!!!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org