Spreadsheet: 469073d1467745762-how-to-calculate-upgrades-at-certain-levels-example-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Upgrade cost
 |  |  |  |  | Tier 1 |  |  |  | [NAME] |  |  |  | Tier 3 |  |  |  |  |  |  | Tier 1 |  |  |  | [NAME] |  |  |  | Tier 3 |  |  |  |  |  | upgrade cost
 |  |  |  |  | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 |  |  | Weapon rank | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 |  | Level 1 |  | Should be: 10 (because only weapon 1 tier 1 is present
 |  |  |  | Level 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 |  | Level 2 |  | Should be: 20+30+120
 |  |  |  | Level 2 | 2 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  | 2 | 20 | 40 | 60 | 80 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 |  | Level 3 |  | Should be: 0 (because no upgrade),  +60, +180
 |  |  |  | Level 3 | 2 |  | 2 |  |  | 2 |  |  |  |  |  |  |  |  | 3 | 30 | 60 | 90 | 120 | 150 | 180 | 210 | 240 | 270 | 300 | 330 | 360 |  | Level 4
 |  |  |  | Level 4 | 3 |  | 2 |  |  |  |  |  | 2 |  |  |  |  |  | 4 | 40 | 80 | 120 | 160 | 200 | 240 | 280 | 320 | 360 | 400 | 440 | 480 |  | Level 5
 |  |  |  | Level 5 | 4 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 5 | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 |  | Level 6
 |  |  |  | Level 6 | 4 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 6 | 60 | 120 | 180 | 240 | 300 | 360 | 420 | 480 | 540 | 600 | 660 | 720 |  | Level 7
 |  |  |  | Level 7 | 8 |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 7 | 70 | 140 | 210 | 280 | 350 | 420 | 490 | 560 | 630 | 700 | 770 | 840 |  | Level 8
 |  |  |  | Level 8 |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  | 8 | 80 | 160 | 240 | 320 | 400 | 480 | 560 | 640 | 720 | 800 | 880 | 960 |  | Level 9
 |  |  |  | Level 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 90 | 180 | 270 | 360 | 450 | 540 | 630 | 720 | 810 | 900 | 990 | 1080 |  | Level 10
 |  |  |  | Level 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 |  | Level 11
 |  |  |  | Level 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 12
 |  |  |  | Level 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 13
 |  |  |  | Level 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 14
 |  |  |  | Level 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 15
 |  |  |  | Level 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 16
 |  |  |  | Level 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 17
 |  |  |  | Level 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 18
 |  |  |  | Level 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Level 19
 |  |  |  | Level 19
 |  |  |  |  | Tier 1 |  |  |  | [NAME] |  |  |  | Tier 3
 |  |  |  |  | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4 | Weapon 1 | Weapon 2 | Weapon 3 | Weapon 4
 |  |  |  | Level 1
 |  |  |  | Level 2
 |  |  |  | Level 3
 |  |  |  | Level 4
 |  |  |  | Level 5
 |  |  |  | Level 6
 |  |  |  | Level 7
 |  |  |  | Level 8
 |  |  |  | Level 9
 |  |  |  | Level 10
 |  |  |  | Level 11
 |  |  |  | Level 12
 |  |  |  | Level 13
 |  |  |  | Level 14
 |  |  |  | Level 15
 |  |  |  | Level 16
 |  |  |  | Level 17
 |  |  |  | Level 18
 |  |  |  | Level 19