Thread: The Weather "Means" rule and spreadsheets
View Single Post
  #8   Report Post  
Old December 29th 12, 10:21 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...
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.


-sigh-
I shall correct my own post.

Odd always rounds UP so it would have to be
=(odd(cell*10-5))/10



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