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

2 comments:

  1. thanks Yogi
    and find what I needed.
    show the solution in case anyone serves
    regards

    A B AVERAGE(A6:B6) CEILING(C6;1/2)
    7 7 7,00 7,00
    7 5,5 6,25 6,50
    7 7,25 7,13 7,50
    7 8,2 7,60 8,00

    ReplyDelete
  2. Thanks Carlos:

    I have also added the following formula using the ceiling function:
    =ArrayFormula(if(A2:A,ceiling(A2:A,0.5),))

    Cheers!
    Yogi

    ReplyDelete