Hi

I would like to have my form do some advanced math if it is possible but need help wrapping my head around it.  

Following is my Grid with calculations in the last 4 columns.  Once the form user selects the fill button these calculations take place.  After these fields are populated with the results we need to determine the "Average Variance" in these Measurement Results. 

The average variance is calculated by adding the largest number and the smallest number in the last 4 columns in the grid table below and dividing that number by 2.  Another words....(Largest number + Smallest number) / 2

Is this possible and if so can you help me with the math calculations in my form.  I am also attaching a file with the actual grid in it so that you can run it and help me wrap my head around this.

As always, thank you very much

Lynda (for Rick)