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

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 - Not working

Solved by S. U. in 14 mins

I WANT FIX FORMULA ERROR PLEASE HELP ME FOR ROUND DOWN AND ROUNDUP

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