using if/then in Word 2000 table

[kimatdsc]

I am trying to get the following formula to work out and need help in
placing the proper functions. I can get the
=SUM(C29,F29,G29,H29,I29,J29)/SUM(F27,I27)/2 part to work fine on its
own, but don't know how to write the "if,then" part of it correctly.
Any help would be greatly appreciated, thank you! - Kim

=IF(I27>0), THEN =SUM(C29,F29,G29,H29,I29,J29)/SUM(F27,I27)/2

Oh yeah, if I27 is 0 then the field should read 0.00, so don't know if
that has to be added to the formula for it to work correctly. Thanks!

 

[Graham Mayor]

Personally I would produce the table as a link from Excel where the
calculations are easier to assemble and automatically recalculate, but this
can be done in a Word table. The following should do the trick.

{IF{=(I27)}>0 "{=SUM(C29,F29,G29,H29,I29,J29)/SUM(F27,I27)/2}" "0.00"}

The {} bracket pairs are placed with CTRL+F9 and the formula is entered
directly into the cell. Then toggle the display with ALT+F9
You will probably need some macro code to force an update on the fields -
and you will probably need to update more than once for multiple
calculations in the table to trickle through.
See http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>