Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Linda Aldrich Linda Aldrich is offline
external usenet poster
 
Posts: 6
Default 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


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 - Protected form will not allow hyperlink to be clicked UPSPaul Microsoft Word Help 11 February 21st 08 12:25 AM
Average calculation Rathish Microsoft Word Help 7 July 23rd 07 11:26 AM
Calculation in a table in a protected form Claud Tables 5 October 26th 06 12:15 AM
How do I create a multiplication calculation in a protected form? Formula Frustrated Frankie Microsoft Word Help 3 May 15th 06 11:14 AM
Automatic update of calculation fields in a protected form Anna Kezer Tables 8 January 28th 06 12:28 AM


All times are GMT +1. The time now is 01:45 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"