Thread: The Weather "Means" rule and spreadsheets
View Single Post
  #7   Report Post  
Old December 29th 12, 10:16 PM posted to uk.sci.weather
Alan LeHun Alan LeHun is offline
external usenet poster
  
First recorded activity by Weather-Banter: Jul 2003
Posts: 735
Default The Weather "Means" rule and spreadsheets
In article ,
says...
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.


are you using excel?

=(odd(cell*10))/10 should do it.

--
Alan LeHun
Reply-to is valid. Add "BPSF" to subject: to bypass spam filters.
Reply With QuoteReply With Quote