Hi
I hope someone can answer this question after a good debate with a friend of mine.

I was calculating some Mean Temps- max and min etc over the last year. My excel spreadsheet carefully rounded the data up to one decimal point. But we discovered that the data didnt match and we hadnt been using the "means rule" where you have to round up or round down depending on the value. My friend calculated the final sum manually, but of course being lazy I want my spreadsheet to do it for me.

E.G of means rule ?
15.05 change 15.1
15.15 leave at 15.1
15.25 change to 15.3
15.35 leave at 15.3
15.45 change to 15.5
15.55 leave at 15.5
15.65 change to 15.7
15.75 leave at 15.7
15.85 change to 15.9
15.95 leave at 15.9
16.05 change to 16.1

Does anyone know how to "programme" a spreadsheet to round up the correct "weather" way to avoid manual calculation.

hope all this makes sense, I did look in the Mr Burts weather observers handbook but I cant find anything relating to this in there.

regards
Paul C
Brampton, Cumbria
www.bramptonweather.co.uk