Google Spreadsheet Post #1081
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Mar 10, 2013
user Shane Dobartz and inspiration from Bas Braams :(http://productforums.google.com/forum/?zx=lp79zfmnqwy4#!category-topic/docs/spreadsheets/GeqGpPPJo9o)
What I am trying to see is if I can "round up" in my google spreadsheet. I need to round up anything above a whole number, i.e. 20.1 to 21, 20.7 to 21, 20.000000000001 to 21, 20.999999 to 21 etc.
Is there anyway to have the format round up regardless if it "should" round down to the nearest whole number?