Wednesday, June 21, 2017

yogi_RoundDown Round And RoundUp Entries In A4:A

Google Spreadsheet   Post  #2189
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-21-2017
question by Robert Reiling:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/FZkqAiimEF0;context-place=forum/docs
How can I round down a number calclated to the next lowest 1/8 of an inch
I have a larege formula that the end result needs to be displayed as a fraction rounded down to the next lower 1/8 inch increment. I can not seem to find a number option for fractions or a round down formula to the next lower 1/8 inch increment.
Any help would be greatly appreciated. I know at minimum the fraction option is in Excel but have had no luck in sheets yet.
Thank you