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
following is a solution to the problem
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
thanks Yogi
ReplyDeleteand 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
Thanks Carlos:
ReplyDeleteI have also added the following formula using the ceiling function:
=ArrayFormula(if(A2:A,ceiling(A2:A,0.5),))
Cheers!
Yogi