# Get instant live expert help on I need help with excel ceiling function

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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