# Problem with showing right numbers after round

#### nova_sweet

##### New Member
Hello,

I am struggeling with the following problem.

I tried to calculate the amount of casenumbers for each worker (1 to 1000 cases) by taking their weekly work-hours into account.
I tried to let Excel do the math without rounding any numbers but in the end I have to because I cannot have a case numbered "345,78", it must be 346. And there it gets wrong sometimes. Not always....I am not very good at math, so probably my math-understanding of it all is the problem.

I uploaded a version of the sheet, because I am not sure how to explain it better. If you check the numbers you will see that somewhere it turns wrong.

Thankful for any input.

Best regards,
nova_sweet

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

#### nova_sweet

##### New Member
Maybe better to show it this way; I did not know how to do this at first ....still not working???

HTML:
``````ABCDEFGH71a20,55,3735%53,735255570010545482s20,55,3735%53,735255570551075493d3910,2228%102,2280472108210102104f307,8637%78,6369593721128879115g3910,2228%102,2280472289391102126h4110,7471%107,4705111392498107137j3910,2228%102,2280472499600102148k307,8637%78,6369593760167979159l256,5531%65,53079948680744661610y3910,2228%102,22804727458471021711r3910,2228%102,22804728489491021812r19,55,1114%51,114023599501000511913v00,0000%00201400,0000%00211500,0000%00221600,0000%00231700,0000%00241800,0000%00251900,0000%00262000,0000%00272100,0000%00282200,0000%00292300,0000%00302400,0000%00312500,0000%0032381,510003334[CENTER][COLOR=#161120][B]Cases 1 to 1000[/B][/COLOR][/CENTER]

Worksheet FormulasCellFormulaC32=SUM(C7:C31)D7=C7/C32E7=D7*1000F7=1G7=IF(\$E7>0,ROUND(SUM(\$E\$7:\$E7),0),"")H7=E7D8=C8/C32E8=D8*1000F8=IF(\$E8>0,SUM(\$E7:\$E\$7)+1,"")G8=IF(\$E8>0,SUM(\$E\$7:\$E8),"")H8=E8D9=C9/C32E9=D9*1000F9=IF(\$E9>0,SUM(\$E\$7:\$E8)+1,"")G9=IF(\$E9>0,SUM(\$E\$7:\$E9),"")H9=E9D10=C10/C32E10=D10*1000F10=IF(\$E10>0,SUM(\$E\$7:\$E9)+1,"")G10=IF(\$E10>0,SUM(\$E\$7:\$E10),"")H10=E10D11=C11/C32E11=D11*1000F11=IF(\$E11>0,SUM(\$E\$7:\$E10)+1,"")G11=IF(\$E11>0,SUM(\$E\$7:\$E11),"")H11=E11D12=C12/C32E12=D12*1000F12=IF(\$E12>0,SUM(\$E\$7:\$E11)+1,"")G12=IF(\$E12>0,SUM(\$E\$7:\$E12),"")H12=E12D13=C13/C32E13=D13*1000F13=IF(\$E13>0,SUM(\$E\$7:\$E12)+1,"")G13=IF(\$E13>0,SUM(\$E\$7:\$E13),"")H13=E13D14=C14/C32E14=D14*1000F14=IF(\$E14>0,SUM(\$E\$7:\$E13)+1,"")G14=IF(\$E14>0,SUM(\$E\$7:\$E14),"")H14=E14D15=C15/C32E15=D15*1000F15=IF(\$E15>0,SUM(\$E\$7:\$E14)+1,"")G15=IF(\$E15>0,SUM(\$E\$7:\$E15),"")H15=E15D16=C16/C32E16=D16*1000F16=IF(\$E16>0,SUM(\$E\$7:\$E15)+1,"")G16=IF(\$E16>0,SUM(\$E\$7:\$E16),"")H16=E16D17=C17/C32E17=D17*1000F17=IF(\$E17>0,SUM(\$E\$7:\$E16)+1,"")G17=IF(\$E17>0,SUM(\$E\$7:\$E17),"")H17=E17D18=C18/C32E18=D18*1000F18=IF(\$E18>0,SUM(\$E\$7:\$E17)+1,"")G18=IF(\$E18>0,SUM(\$E\$7:\$E18),"")H18=E18D19=C19/C32E19=D19*1000F19=IF(\$E19>0,SUM(\$E\$7:\$E18)+1,"")G19=IF(\$E19>0,SUM(\$E\$7:\$E19),"")H19=E19D20=C20/C32E20=D20*1000F20=IF(\$E20>0,SUM(\$E\$7:\$E19)+1,"")G20=IF(\$E20>0,SUM(\$E\$7:\$E20),"")H20=E20D21=C21/C32E21=D21*1000F21=IF(\$E21>0,SUM(\$E\$7:\$E20)+1,"")G21=IF(\$E21>0,SUM(\$E\$7:\$E21),"")H21=E21D22=C22/C32E22=D22*1000F22=IF(\$E22>0,SUM(\$E\$7:\$E21)+1,"")G22=IF(\$E22>0,SUM(\$E\$7:\$E22),"")H22=E22D23=C23/C32E23=D23*1000F23=IF(\$E23>0,SUM(\$E\$7:\$E22)+1,"")G23=IF(\$E23>0,SUM(\$E\$7:\$E23),"")H23=E23D24=C24/C32E24=D24*1000F24=IF(\$E24>0,SUM(\$E\$7:\$E23)+1,"")G24=IF(\$E24>0,SUM(\$E\$7:\$E24),"")H24=E24D25=C25/C32E25=D25*1000F25=IF(\$E25>0,SUM(\$E\$7:\$E24)+1,"")G25=IF(\$E25>0,SUM(\$E\$7:\$E25),"")H25=E25D26=C26/C32E26=D26*1000F26=IF(\$E26>0,SUM(\$E\$7:\$E25)+1,"")G26=IF(\$E26>0,SUM(\$E\$7:\$E26),"")H26=E26D27=C27/C32E27=D27*1000F27=IF(\$E27>0,SUM(\$E\$7:\$E26)+1,"")G27=IF(\$E27>0,SUM(\$E\$7:\$E27),"")H27=E27D28=C28/C32E28=D28*1000F28=IF(\$E28>0,SUM(\$E\$7:\$E27)+1,"")G28=IF(\$E28>0,SUM(\$E\$7:\$E28),"")H28=E28D29=C29/C32E29=D29*1000F29=IF(\$E29>0,SUM(\$E\$7:\$E28)+1,"")G29=IF(\$E29>0,SUM(\$E\$7:\$E29),"")H29=E29D30=C30/C32E30=D30*1000F30=IF(\$E30>0,SUM(\$E\$7:\$E29)+1,"")G30=IF(\$E30>0,SUM(\$E\$7:\$E30),"")H30=E30D31=C31/C32E31=D31*1000F31=IF(\$E31>0,SUM(\$E\$7:\$E30)+1,"")G31=IF(\$E31>0,SUM(\$E\$7:\$E31),"")H31=E31E32=SUM(E7:E31)``````

Last edited: Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,167,531
Messages
5,854,284
Members
431,636
Latest member
shabbas313 ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back