Subtract formula

C

Candace

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

Jean-Guy Marcil

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?
Click to expand...

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
[email protected]
Word MVP site: http://www.word.mvps.org
 
C

Candace

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?
 
C

Candace

Never-mind. It worked fine when I used your {=(C23-C24)} suggestion, but
without the braces. Thanks so much!!!
 
S

Suzanne S. Barnhill

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).
 
J

Jean-Guy Marcil

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. 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).
Click to expand...

My bad!

I should have been more explicit!

Thanks.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top