Round forecast values up or down depending on cumulative decimal value.

Hi guys,

I hope the title makes sense..

I have the following problem:

In excel, i am calculating a weekly forecast for many items.
The forecast is calculated as a decimal value and the lowest value will be 0.1, or 1500 for example.
I have to round the numbers up or down to an integer value.

My problem is especially with lower values, rounding up or down really messes up the yearly forecast.

Example 1:
Weekly forecast: 0.2 per week
Yearly forecast should be ~0.2*53 = 10,6
Rounded down Yearly forecast = 0

Example 2:
Weekly forecast: 0.6 per week
Yearly forecast should be ~1.6*53 = 84,8
Rounded up Yearly forecast = 106

Do you guys know a way to rond up/down like this:
Calculated per week: 1.2 - 1.2 - 1.2 - 1.2 - 1.2 - 1.2 - 1.2 - 1.2 - 1.2 - 1.2...
Rounded: 1 - 1 - 1 - 1 - 2 - 1 - 1 - 1 - 1 - 2...

I can probably do this with VBA but i hope there is a more sophisticated way.

Thanks!