using if/then in Word 2000 table

  • Thread starter Thread starter kimatdsc
  • Start date Start date
K

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!
 
Hi Kim,

Using Ctrl+F9 to insert the field delimiters { }

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

Alt+F9 to toggle off the field codes and F9 to update the field to show the
result.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 
Back
Top