Sunday, June 4, 2017

yogi_Round Entries (greater than or less than 1) To Nearest Specified Number

Google Spreadsheet   Post  #2173
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-04-2017
question by SolveAllProblemsRightNow:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/rO5IdnrVgz0;context-place=forum/docs
[ g-excel ] -- rounding to the nearest 5 -- chrome extension, functions, etc.

6 > 5
.7 > .5
13 > 15
.022 > .020
1368 > 1370
that's what call rounding to the nearest 5, 10, 15, 20...
* what function or chrome extension or any solution that can do this?
* can excel do this?

---
see unsolved here -> https://paper.dropbox.com/doc/2015-2025-THE-FUCKING-HELL-OF-GOOGLE-SOFTWARE-HOLY-SHIT-LIST-OF-G-PROBLEMS-6TYv5Ye144H2PQY4HhQLM