Respected,forum.ozgrid.com/index.php?attachment/68818/
I have to calculate average of attached an excel 20-25 reading in which there are various combination like
0.01, -0, -0.01 and 0,
The format comes from the station which takes the reading so I am not able to control them.
There are about 200 such calculation daily so at present I have to modify formulae for each to adjust .
I am looking for a formaule which applies and give correct result though the readings can be in any format.
I have attached xls file to make the things clear
Zohar Batterywala