Get instant live Excel expert help to learn how to round up a number in 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

Basically for each entry in the "Packet Games" section we can have multiple winners and they can be both Single and Double winners. One single winner would win 40.00 as long as they are the only winner, and the payout needs to round up to the nearest .25 If n15>0 then calculate using O13 to complete Roundup(O13/C5/0.25,0)*0.25. The excel roundup function is not working
Solved by S. U. in 14 mins
I WANT FIX FORMULA ERROR PLEASE HELP ME FOR ROUND DOWN AND ROUNDUP FUNCTION.
Solved by I. A. in 16 mins
I want to express any number with a fraction to roundup to the nearest 1/3, 2/3 or 1. Example: 121.001- 121.333= 121 1/3 121.334- 121.666= 121 2/3 121.667- 121.999= 122 OR IF CELL A1= 131.001- 131.333 THEN RETURN 131 1/3 IF CELL A1= 131.334- 131.666 THEN RETURN 131 2/3 IF CELL A1= 131.667- 131.999 THEN RETURN 132
Solved by E. Q. in 12 mins
I need a formula to divide a dollar amount by a number of months and then roundup the answer to the nearest dollar.
Solved by V. J. in 21 mins
I need a formulas using only this functions , Mod IF and or round roundup sqrt min max sin cos to figure out how many hrs does a take to do a job Example. 10 to 20k 30 hrs 20001 to 30 k 60 hrs and so on increments of 10 k increments of 30 hrs
Solved by D. H. in 30 mins
i have cell E5 & F5 to imput either quantity in pieces or in total linear feet to show in cell A5, so far i have the 2 conditions when input is in E5 this is the formula =IF(E5>0,E5*21," ") , when input is in F5 this is the formula =IF(F5>0,ROUNDUP(F5/21,0)*21," ") ,what i am trying to do is the following : the formula should only allow 1 input from either E5 or F5
Solved by O. W. in 13 mins
I am trying to use date roundup but it's seam difficult to use. Could you guide me to use this formula?
Solved by D. J. in 24 mins
ROUNDUP(SUMIF(Data!$F$6:$F$466,Summary!D4,Data!$Y$6:$Y$466),2)
Solved by E. E. in 27 mins
I have measurement I want to put into a cell and then have it divide by 10 then roundup to whole number and then add 4. So I have =ROUNDUP(A82/10,0)+4. the issue I have is if there is zero for the measurement it still returns a value of 4.
Solved by T. H. in 21 mins
Excel formula problem. Trying a autosum function where I am dividing a cell value by 3, but within the same cell want to roundup the answer in the cell to the next whole number even if value is less than 0.5 and more than 0.5
Solved by E. Q. in 19 mins
2