Spreadsheet: 287579d1388870048-excel-price-list-automatically-re-calculated-with-f-surcharge-and-discount-how-to-shipping_rates
Sheet: Scenario 1

 | When "%"`s are keyed in C3 and C4 all  values (prices) in the price list (green cells) should change. (As per calculation shown in the example on the right) |  |  |  |  |  |  |  |  |  | This is just example that should show, how price (from green cells) should be taken, recalculated, returned and shown when [NAME] and C4 value is diferent than 0%.
 | [NAME] | 0.1 |  |  |  |  |  |  |  |  | Published Price | 100
 | Discount | 0.14 |  |  |  |  |  |  |  |  | Fuel surcharge | 0.15
 |  |  |  |  |  |  |  |  |  |  | Discount | 0.2
 |  |  |  |  |  |  |  |  |  |  | Final Price
 |  |  |  |  |  |  |  |  |  |  | (*Remark: Fuel surcharge is not part of the discount.)
 | Envelopes1
 |  |  | zone |  | zone |  | zone |  | zone |  | zone |  | zone
 |  |  | 1 |  | 2 |  | 3 |  | 6 |  | 7 |  | 8
 | EUR |  | 93.4 |  | 94.6 |  | 96.8 |  | 97.4 |  | 103.7 |  | 109.45
 | Documents up to 5.0kg other than  Envelopes
 | weight
 | 0.5 kg |  | 98 |  | 100.25 |  | 105.45 |  | 107.7 |  | 114.1 |  | 121.55
 | 1.0 kg |  | 108.35 |  | 110.6 |  | 117 |  | 120.95 |  | 129.05 |  | 137.65
 | 1.5 kg |  | 117.55 |  | 119.75 |  | 127.85 |  | 133.6 |  | 143.35 |  | 153.2
 | 2.0 kg |  | 127.3 |  | 129.6 |  | 138.25 |  | 146.3 |  | 157.75 |  | 168.65
 | 2.5 kg |  | 136.5 |  | 138.75 |  | 149.15 |  | 158.95 |  | 171.55 |  | 184.2
 | 3.0 kg |  | 142.25 |  | 146.3 |  | 156.05 |  | 166.95 |  | 183.1 |  | 195.15
 | 3.5 kg |  | 147.4 |  | 153.2 |  | 163.5 |  | 175.55 |  | 194.5 |  | 206.05
 | 4.0 kg |  | 152.55 |  | 160.65 |  | 170.35 |  | 183.65 |  | 206.05 |  | 216.4
 | 4.5 kg |  | 157.75 |  | 167.5 |  | 177.9 |  | 192.25 |  | 216.95 |  | 227.3
 | 5.0 kg |  | 163.5 |  | 174.45 |  | 184.8 |  | 200.3 |  | 228.5 |  | 238.25
 | Documents over 5.0kg and Packages
 |  |  | zone |  | zone |  | zone |  | zone |  | zone |  | zone
 | EUR |  | 1 |  | 2 |  | 3 |  | 6 |  | 7 |  | 8
 | weight
 | 0.5 kg |  | 120.95 |  | 122.2 |  | 127.35 |  | 130.75 |  | 138.25 |  | 145.7
 | 1.0 kg |  | 129.1 |  | 130.15 |  | 139.95 |  | 145.75 |  | 152.6 |  | 162.4
 | 1.5 kg |  | 137.1 |  | 138.75 |  | 152.05 |  | 158.95 |  | 166.95 |  | 177.95
 | 2.0 kg |  | 144.6 |  | 146.8 |  | 163.55 |  | 172.15 |  | 181.4 |  | 193.5
 | 2.5 kg |  | 152.55 |  | 155.5 |  | 175.6 |  | 185.4 |  | 195.7 |  | 208.95
 | 3.0 kg |  | 158.4 |  | 161.2 |  | 182.5 |  | 194 |  | 206.1 |  | 222.7
 | 3.5 kg |  | 164.1 |  | 167.55 |  | 190 |  | 202.05 |  | 215.9 |  | 236.55
 | 4.0 kg |  | 170.4 |  | 173.3 |  | 196.9 |  | 210.7 |  | 226.15 |  | 250.3
 | 4.5 kg |  | 176.2 |  | 179.05 |  | 204.4 |  | 219.25 |  | 236.55 |  | 264.15
 | 5.0 kg |  | 181.9 |  | 185.35 |  | 211.3 |  | 227.3 |  | 246.35 |  | 277.95
 | 5.5 kg |  | 187.05 |  | 191.05 |  | 218.1 |  | 235.9 |  | 254.9 |  | 287.7
 | 6.0 kg |  | 191.75 |  | 196.9 |  | 224.4 |  | 244.05 |  | 263.55 |  | 298.1
 | 6.5 kg |  | 196.3 |  | 203.15 |  | 230.75 |  | 252.6 |  | 271.6 |  | 308.4
 | 7.0 kg |  | 201.45 |  | 208.9 |  | 237.7 |  | 260.65 |  | 280.2 |  | 318.8
 | 7.5 kg |  | 206.05 |  | 214.7 |  | 244.05 |  | 269.25 |  | 288.25 |  | 328.5
 | 8.0 kg |  | 210.7 |  | 220.95 |  | 250.3 |  | 277.9 |  | 296.9 |  | 338.85
 | 8.5 kg |  | 215.2 |  | 226.8 |  | 257.2 |  | 286 |  | 305.5 |  | 349.2
 | 9.0 kg |  | 220.45 |  | 232.5 |  | 263.55 |  | 294.55 |  | 313.55 |  | 359
 | 9.5 kg |  | 225.05 |  | 238.8 |  | 270.4 |  | 302.6 |  | 322.2 |  | 369.3
 | 10 kg |  | 229.6 |  | 244.6 |  | 276.7 |  | 311.25 |  | 330.2 |  | 379.65
 | 11 kg |  | 237.7 |  | 252.6 |  | 286 |  | 321.55 |  | 342.9 |  | 392.35
 | 12 kg |  | 245.1 |  | 260.1 |  | 294.55 |  | 331.35 |  | 355.55 |  | 404.95
 | 13 kg |  | 253.2 |  | 267.5 |  | 303.8 |  | 341.75 |  | 368.2 |  | 417
 | 14 kg |  | 260.65 |  | 275.6 |  | 312.4 |  | 352.1 |  | 380.8 |  | 429.65
 | 15 kg |  | 268.7 |  | 283.1 |  | 321.55 |  | 362.45 |  | 393.5 |  | 442.3
 | 16 kg |  | 276.2 |  | 291.15 |  | 330.2 |  | 372.15 |  | 406.1 |  | 454.35
 | 17 kg |  | 283.6 |  | 298.6 |  | 339.4 |  | 382.55 |  | 418.75 |  | 466.4
 | 18 kg |  | 291.75 |  | 306.7 |  | 348 |  | 392.85 |  | 430.85 |  | 478.55
 | 19 kg |  | 299.1 |  | 314.2 |  | 357.25 |  | 402.65 |  | 443.45 |  | 490.65
 | 20 kg |  | 307.2 |  | 322.2 |  | 365.85 |  | 413.05 |  | 456.1 |  | 502.1
 | 21 kg |  | 314.2 |  | 329.65 |  | 374.55 |  | 422.75 |  | 467.6 |  | 514.15
 | 22 kg |  | 321.55 |  | 337.65 |  | 382.55 |  | 432.55 |  | 479.1 |  | 526.3
 | 23 kg |  | 328.5 |  | 345.15 |  | 391.15 |  | 441.75 |  | 490.65 |  | 538.4
 | 24 kg |  | 335.4 |  | 352.65 |  | 399.2 |  | 451.55 |  | 501.6 |  | 550.4
 | 25 kg |  | 342.9 |  | 360.75 |  | 407.85 |  | 461.25 |  | 513.05 |  | 562.5
 | 26 kg |  | 349.75 |  | 368.2 |  | 415.9 |  | 470.5 |  | 524.55 |  | 573.95
 | 27 kg |  | 357.25 |  | 376.25 |  | 424.45 |  | 480.25 |  | 536 |  | 586.1
 | 28 kg |  | 364.15 |  | 383.65 |  | 432.55 |  | 490 |  | 547.5 |  | 598.1
 | 29 kg |  | 371.65 |  | 391.65 |  | 441.25 |  | 499.2 |  | 558.4 |  | 610.2
 | 30 kg |  | 378.55 |  | 399.2 |  | 449.2 |  | 509 |  | 570 |  | 622.25
 | 31 kg |  | 385.4 |  | 407.25 |  | 457.85 |  | 518.75 |  | 580.85 |  | 633.8
 | 32 kg |  | 392.85 |  | 414.75 |  | 465.9 |  | 528 |  | 591.75 |  | 644.75
 | 33 kg |  | 399.8 |  | 422.75 |  | 474.55 |  | 537.7 |  | 602.1 |  | 656.2
 | 34 kg |  | 407.25 |  | 430.3 |  | 482.6 |  | 547.5 |  | 613.1 |  | 667.65
 | 35 kg |  | 414.15 |  | 437.7 |  | 491.2 |  | 556.7 |  | 624 |  | 679.15
 | 40 kg |  | 453.25 |  | 480.85 |  | 530.3 |  | 603.85 |  | 683.75 |  | 742.4
 | 45 kg |  | 492.9 |  | 523.95 |  | 569.3 |  | 650.45 |  | 743.55 |  | 806.2
 | 50 kg |  | 532 |  | 566.45 |  | 609 |  | 697 |  | 803.9 |  | 869.45
 | 55 kg |  | 571.1 |  | 609.6 |  | 648.15 |  | 743.55 |  | 863.65 |  | 933.25
 | 60 kg |  | 610.75 |  | 652.15 |  | 687.2 |  | 790.7 |  | 923.55 |  | 996.5
 | 65 kg |  | 649.85 |  | 695.3 |  | 726.35 |  | 837.3 |  | 983.25 |  | 1060.3
 | 70 kg |  | 688.9 |  | 737.8 |  | 765.95 |  | 883.85 |  | 1043.05 |  | 1123.55