“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to add ceiling to array formulas..

Solved by I. J. in 14 mins

I want to do ceiling for the sum value while calculating sum.

Solved by B. B. in 16 mins

I need a formula that will give me a zero until I input data then return the answer in the following
=SUM(CEILING((D52*B52)*100,1)/D52)

Solved by G. B. in 19 mins

I'm using the CEILING formula to calculate the duration between start/end times (round up to each 6 minute increments), in the form of a decimal number. Example, 6:00 to 6:30 is 0.5 hour (=CEILING ((B2-A2)*24, 6/60). For some reason, each 6th minute mark is counted UP, so instead of getting "0.5" I'm getting "0.6"

Solved by V. U. in 12 mins

I need help with a formula to combine two formulas... =IF(AND(B5=0,B4=0,"0",”IF(B5=0,"12",(CEILING(C5/25,12)))

Solved by V. A. in 25 mins