hi,
i have the following table which needs to figure out costs for going from a level to another level. the cost of each level is shown in column D. in column E you see if that level is "incremental" or "not incremental".
if a level IS incremental (Y), that means that the cost of going from one level to the next is the difference between the cost of the two levels.
if a level is None incremental (N) then the cost of going from one level to the next is the total cost of the new level.
G4:K4 show the level i'm starting with (hypathatically)
i'm trying to fill G5:K9 (only the white parts cause you can only go UP in levels)
i have the following table which needs to figure out costs for going from a level to another level. the cost of each level is shown in column D. in column E you see if that level is "incremental" or "not incremental".
if a level IS incremental (Y), that means that the cost of going from one level to the next is the difference between the cost of the two levels.
if a level is None incremental (N) then the cost of going from one level to the next is the total cost of the new level.
| Book1 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| D | E | F | G | H | I | J | K | |||
| 4 | Incremental | Level | 0 | 1 | 2 | 3 | 4 | |||
| 5 | $40 | N | 4 | |||||||
| 6 | $30 | N | 3 | |||||||
| 7 | $20 | Y | 2 | |||||||
| 8 | $10 | N | 1 | |||||||
| 9 | $0 | 0 | ||||||||
Sheet1 | ||||||||||
G4:K4 show the level i'm starting with (hypathatically)
i'm trying to fill G5:K9 (only the white parts cause you can only go UP in levels)
