DIFFERENCE IN VALUE

Please see below table

 

No. of beneficiaries Actual Diet Total Poshahar Days No of AWCs where Poshahar distributed
15 16 17 18
2263 40382 1320 74
8929 214296 6744 281
4831 114258 4848 205
6558 157404 6408 267
6478 149308 4932 214
4968 119016 3162 132
11321 271716 6432 268
6885 163608 5513 232
4447 106728 3408 142
8414 201952 5328 222
9372 177380 3785 200
5707 137184 3942 164
7709 185268 4614 192
11840 283128 6552 274
8888 133550 3516 234
108610 2455178 70504 3101

the formula applied in No. of beneficiaries is =int((Actual Diet*No of AWCs where Poshahar distributed)/Total Poshahar Days) 

The lowest bold row shows the sum of the column. 

My question when I put above formula in total values i.e. =int((2455178*3101)/70504) the output comes 107986 which is 624 less than 108610, why does it happen?

By: Ravi kant

Leave a Reply

Your email address will not be published. Required fields are marked *