*(Total Production Figure for the year minus Current Production Figure) divided by (52 weeks minus Current week number)*which gives me a list of figures with a number of decimal places.

My problem is, if I use the "ROUND" fuction to rduce them to integers, the column the totals more than the total production figure for the year.

Is there a way around this?

Hope this makes sense, thanks in advance.