Saturday, December 8, 2012

yogi_Round Numbers In Column A Per Criteria Specified In Column B And Present Results In Column C

                                          Google Spreadsheet   Post  #919
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 8, 2012
user Carlos Bettera said:(http://productforums.google.com/forum/?zx=85hivgm1a4uy#!category-topic/docs/spreadsheets/28G2UJShW-g)
function spread sheet

Hello, I need help with the following:
I have to round up to two decimal places, for example:
7.09 to 7.50;
7.50 to 7.50
7.62 to 8.00

thanks nuchas
-----------------------------------------------------------------------------------------

following is a solution to the problem