Get instant live expert help on ceiling function excel

“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