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!
Bookmarks