Average Calculation in a Protected Form - Word 2003
Hi,
I have used the calcuation expression within a table form field, using the
bookmarks for each of the fields. If the fields have a '0' value they get
averaged into the final figure. How do I dis-include the '0' values from
the average? Below is the expression for the Form Field "intAverPMBPD":
=AVERAGE(intPMBPD1,intPMBPD2,intPMBPD3,intPMBPD4,i ntPMBPD5,intPMBPD6,intPMBPD7)
Thank you for any help you can provide!
Linda
|