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    Jan 16, 2013
user dpet102 said:(!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