using if/then in Word 2000 table

[kimatdsc]

This is actually a Word 2000 question and it looks like this may not be the correct forum, but Im desperate and cant seem to find an answer to my problem, so maybe someone here could help me??

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 dont know how to write the "if,then" part of it correctly. I know I dont use the word "then," but wrote it out so hopefully the logic comes across of what I need.

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 dont know if that has to be added to the formula for it to work correctly. Thanks!

 

[techmanbd]

This is the logic

=if(logical, if true, if false)

so here is what yours will look like
=if(127 > 0, (SUM(C29,F29,G29,H29,I29,J29)/SUM(F27,I27)/2), 0)

 

[kimatdsc]

THANK YOU!

THANK YOU SO MUCH, you are my HERO!