On Fri, 7 Oct 2005 20:41:21 -0700, "Peo Sjoblom"
wrote:


OK thanks very much Peo I'll give that a shot.
It should work out just fine.

Eric



Although I have a pocket pc I never really use excel except when I first got
it and soon realized it was of little help but in general you have to use
multiple formulas, i.e.

=IF(AND(C4<"",C2<""),C4/C2)

copy across 6 columns

assume you put that and copy across from C8 to H8 thus instead of using an
array calculate each cell individually, then finish off with

=AVERAGE(C8:H8)*100

which should give the same answer