View Single Post
  #20   Report Post  
Old December 31st 12, 02:36 PM posted to uk.sci.weather
Martin Brown Martin Brown is offline
external usenet poster
 
First recorded activity by Weather-Banter: Nov 2003
Posts: 935
Default The Weather "Means" rule and spreadsheets

On 31/12/2012 09:36, Paul Crabtree wrote:
Thanks for all the replies !!!

Appeared to have sparked a little interest in the subject

best wishes for the new year

Paul C


You would have to create a UDF to allow you access to the VBA macro
implementation or roll your own very clumsy implementation via a string
intermediate stage. More details about Excel rounding online at:

http://support.microsoft.com/kb/196652

It still isn't pretty since you will have to add and subtract 1 in the
LSB to get weathermens rounding as opposed to bankers rounding.


--
Regards,
Martin Brown