Wednesday, January 16, 2013

yogi_Round a Column Of Entries To A Specified Number Up Or Down As Specified


                                          Google Spreadsheet  Post  #974
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 16, 2013
user dpet102 said:(http://productforums.google.com/forum/?zx=yxsj47yocabe#!category-topic/docs/spreadsheets/J9ytP05Jk3U)
Round down to Nearest 5
Hey y'all!

I'm trying to round a number down to the nearest 5, where 836.2 rounds to 835 and 839.9 rounds down to 835, 840.1 rounds to 840 and 844.3, rounds to 840, etc. Ideas?
--------------------------------------------------------------------------------------------
following is a solution to a bit more generalised problem