Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
Hi all!!
I've been having this problem for as long as I can remember, I think its kind of tricky, so read on...
I allocate devices across the state, to districts, according to a funding formula.
I'll enter the total amount of an item in the total column, and the item should be divided according to the funding formula, as follows:
You can see the problem, because I need whole items, the actual sum is off.
Can I make Excel allocate these items while rounding to whole numbers, and still maintain a proper sum??
Thanks as always,
Corticus
I've been having this problem for as long as I can remember, I think its kind of tricky, so read on...
I allocate devices across the state, to districts, according to a funding formula.
I'll enter the total amount of an item in the total column, and the item should be divided according to the funding formula, as follows:
Book2 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | |||
2 | District | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total | Calculated | ||
3 | Formula | 5% | 10% | 15% | 8% | 22% | 24% | 9% | 7% | 100% | Total | ||
4 | Device1 | 3 | 5 | 8 | 4 | 11 | 12 | 5 | 4 | 50 | 52 | ||
5 | Device2 | 1 | 2 | 3 | 2 | 4 | 5 | 2 | 1 | 20 | 20 | ||
6 | Device3 | 4 | 8 | 12 | 6 | 18 | 19 | 7 | 6 | 80 | 80 | ||
7 | Device4 | 4 | 7 | 11 | 6 | 15 | 17 | 6 | 5 | 70 | 71 | ||
8 | Device5 | 2 | 4 | 6 | 3 | 9 | 10 | 4 | 3 | 40 | 41 | ||
Sheet1 |
You can see the problem, because I need whole items, the actual sum is off.
Can I make Excel allocate these items while rounding to whole numbers, and still maintain a proper sum??
Thanks as always,
Corticus