Wanted to share Canada Taxes Salary Component formula

It took me a while to understand and create the formula so I wanted all to be able to have it easily.

Here is the formula for Federal Tax :

0 if (SL >= 0 and SL <= 619.99) else 0.35 if (SL >= 622 and SL <= 625.99) else 0.8 if (SL >= 626 and SL <= 629.99) else 1.25 if (SL >= 630 and SL <= 633.99) else 1.75 if (SL >= 634 and SL <= 637.99) else 2.2 if (SL >= 638 and SL <= 641.99) else 2.65 if (SL >= 642 and SL <= 645.99) else 3.1 if (SL >= 646 and SL <= 649.99) else 3.55 if (SL >= 650 and SL <= 653.99) else 4.05 if (SL >= 654 and SL <= 657.99) else 4.5 if (SL >= 658 and SL <= 661.99) else 4.95 if (SL >= 662 and SL <= 665.99) else 5.4 if (SL >= 666 and SL <= 669.99) else 5.9 if (SL >= 670 and SL <= 673.99) else 6.35 if (SL >= 674 and SL <= 677.99) else 6.8 if (SL >= 678 and SL <= 681.99) else 7.25 if (SL >= 682 and SL <= 685.99) else 7.7 if (SL >= 686 and SL <= 689.99) else 8.2 if (SL >= 690 and SL <= 693.99) else 8.65 if (SL >= 694 and SL <= 697.99) else 9.1 if (SL >= 698 and SL <= 701.99) else 9.55 if (SL >= 702 and SL <= 705.99) else 10.05 if (SL >= 706 and SL <= 709.99) else 10.5 if (SL >= 710 and SL <= 713.99) else 10.95 if (SL >= 714 and SL <= 717.99) else 11.4 if (SL >= 718 and SL <= 721.99) else 11.85 if (SL >= 722 and SL <= 725.99) else 12.35 if (SL >= 726 and SL <= 729.99) else 12.8 if (SL >= 730 and SL <= 733.99) else 13.25 if (SL >= 734 and SL <= 737.99) else 13.7 if (SL >= 738 and SL <= 741.99) else 14.2 if (SL >= 742 and SL <= 745.99) else 14.65 if (SL >= 746 and SL <= 749.99) else 15.1 if (SL >= 750 and SL <= 753.99) else 15.55 if (SL >= 754 and SL <= 757.99) else 16 if (SL >= 758 and SL <= 761.99) else 16.5 if (SL >= 762 and SL <= 765.99) else 16.95 if (SL >= 766 and SL <= 769.99) else 17.4 if (SL >= 770 and SL <= 773.99) else 17.85 if (SL >= 774 and SL <= 777.99) else 18.35 if (SL >= 778 and SL <= 781.99) else 18.8 if (SL >= 782 and SL <= 785.99) else 19.25 if (SL >= 786 and SL <= 789.99) else 19.7 if (SL >= 790 and SL <= 793.99) else 20.15 if (SL >= 794 and SL <= 797.99) else 20.65 if (SL >= 798 and SL <= 801.99) else 21.1 if (SL >= 802 and SL <= 805.99) else 21.55 if (SL >= 806 and SL <= 809.99) else 22 if (SL >= 810 and SL <= 813.99) else 22.5 if (SL >= 814 and SL <= 817.99) else 22.95 if (SL >= 818 and SL <= 821.99) else 23.4 if (SL >= 822 and SL <= 825.99) else 23.85 if (SL >= 826 and SL <= 829.99) else 24.3 if (SL >= 830 and SL <= 833.99) else 24.8 if (SL >= 834 and SL <= 837.99) else 25.45 if (SL >= 838 and SL <= 845.99) else 26.4 if (SL >= 846 and SL <= 853.99) else 27.3 if (SL >= 854 and SL <= 861.99) else 28.25 if (SL >= 862 and SL <= 869.99) else 29.15 if (SL >= 870 and SL <= 877.99) else 30.1 if (SL >= 878 and SL <= 885.99) else 31 if (SL >= 886 and SL <= 893.99) else 31.95 if (SL >= 894 and SL <= 901.99) else 32.85 if (SL >= 902 and SL <= 909.99) else 33.75 if (SL >= 910 and SL <= 917.99) else 34.7 if (SL >= 918 and SL <= 925.99) else 35.6 if (SL >= 926 and SL <= 933.99) else 36.55 if (SL >= 934 and SL <= 941.99) else 37.45 if (SL >= 942 and SL <= 949.99) else 38.4 if (SL >= 950 and SL <= 957.99) else 39.3 if (SL >= 958 and SL <= 965.99) else 40.25 if (SL >= 966 and SL <= 973.99) else 41.15 if (SL >= 974 and SL <= 981.99) else 42.05 if (SL >= 982 and SL <= 989.99) else 43 if (SL >= 990 and SL <= 997.99) else 43.9 if (SL >= 998 and SL <= 1005.99) else 44.85 if (SL >= 1006 and SL <= 1013.99) else 45.75 if (SL >= 1014 and SL <= 1021.99) else 46.7 if (SL >= 1022 and SL <= 1029.99) else 47.6 if (SL >= 1030 and SL <= 1037.99) else 48.55 if (SL >= 1038 and SL <= 1045.99) else 49.45 if (SL >= 1046 and SL <= 1053.99) else 50.35 if (SL >= 1054 and SL <= 1061.99) else 51.3 if (SL >= 1062 and SL <= 1069.99) else 52.2 if (SL >= 1070 and SL <= 1077.99) else 53.15 if (SL >= 1078 and SL <= 1085.99) else 54.05 if (SL >= 1086 and SL <= 1093.99) else 55 if (SL >= 1094 and SL <= 1101.99) else 55.9 if (SL >= 1102 and SL <= 1109.99) else 56.8 if (SL >= 1110 and SL <= 1117.99) else 57.75 if (SL >= 1118 and SL <= 1125.99) else 58.65 if (SL >= 1126 and SL <= 1133.99) else 59.6 if (SL >= 1134 and SL <= 1141.99) else 60.5 if (SL >= 1142 and SL <= 1149.99) else 61.45 if (SL >= 1150 and SL <= 1157.99) else 62.35 if (SL >= 1158 and SL <= 1165.99) else 63.3 if (SL >= 1166 and SL <= 1173.99) else 64.2 if (SL >= 1174 and SL <= 1181.99) else 65.1 if (SL >= 1182 and SL <= 1189.99) else 66.05 if (SL >= 1190 and SL <= 1197.99) else 66.95 if (SL >= 1198 and SL <= 1205.99) else 67.9 if (SL >= 1206 and SL <= 1213.99) else 68.8 if (SL >= 1214 and SL <= 1221.99) else 69.75 if (SL >= 1222 and SL <= 1229.99) else 70.65 if (SL >= 1230 and SL <= 1237.99) else 71.6 if (SL >= 1238 and SL <= 1245.99) else 72.5 if (SL >= 1246 and SL <= 1253.99) else 73.4 if (SL >= 1254 and SL <= 1261.99) else 74.35 if (SL >= 1262 and SL <= 1269.99) else 75.25 if (SL >= 1270 and SL <= 1277.99) else 76.65 if (SL >= 1278 and SL <= 1293.99) else 78.5 if (SL >= 1294 and SL <= 1309.99) else 80.35 if (SL >= 1310 and SL <= 1325.99) else 82.2 if (SL >= 1326 and SL <= 1341.99) else 84.05 if (SL >= 1342 and SL <= 1357.99) else 85.85 if (SL >= 1358 and SL <= 1373.99) else 87.7 if (SL >= 1374 and SL <= 1389.99) else 89.55 if (SL >= 1390 and SL <= 1405.99) else 91.4 if (SL >= 1406 and SL <= 1421.99) else 93.25 if (SL >= 1422 and SL <= 1437.99) else 95.1 if (SL >= 1438 and SL <= 1453.99) else 96.95 if (SL >= 1454 and SL <= 1469.99) else 98.8 if (SL >= 1470 and SL <= 1485.99) else 100.6 if (SL >= 1486 and SL <= 1501.99) else 102.45 if (SL >= 1502 and SL <= 1517.99) else 104.3 if (SL >= 1518 and SL <= 1533.99) else 106.15 if (SL >= 1534 and SL <= 1549.99) else 108 if (SL >= 1550 and SL <= 1565.99) else 109.85 if (SL >= 1566 and SL <= 1581.99) else 111.7 if (SL >= 1582 and SL <= 1597.99) else 113.55 if (SL >= 1598 and SL <= 1613.99) else 115.4 if (SL >= 1614 and SL <= 1629.99) else 117.2 if (SL >= 1630 and SL <= 1645.99) else 119.05 if (SL >= 1646 and SL <= 1661.99) else 120.9 if (SL >= 1662 and SL <= 1677.99) else 122.75 if (SL >= 1678 and SL <= 1693.99) else 124.6 if (SL >= 1694 and SL <= 1709.99) else 126.45 if (SL >= 1710 and SL <= 1725.99) else 128.3 if (SL >= 1726 and SL <= 1741.99) else 130.15 if (SL >= 1742 and SL <= 1757.99) else 132 if (SL >= 1758 and SL <= 1773.99) else 133.8 if (SL >= 1774 and SL <= 1789.99) else 135.65 if (SL >= 1790 and SL <= 1805.99) else 137.5 if (SL >= 1806 and SL <= 1821.99) else 139.35 if (SL >= 1822 and SL <= 1837.99) else 141.2 if (SL >= 1838 and SL <= 1853.99) else 143.05 if (SL >= 1854 and SL <= 1869.99) else 144.9 if (SL >= 1870 and SL <= 1885.99) else 147.15 if (SL >= 1886 and SL <= 1901.99) else 149.7 if (SL >= 1902 and SL <= 1917.99) else 152.3 if (SL >= 1918 and SL <= 1933.99) else 154.85 if (SL >= 1934 and SL <= 1949.99) else 157.45 if (SL >= 1950 and SL <= 1965.99) else 160 if (SL >= 1966 and SL <= 1981.99) else 162.6 if (SL >= 1982 and SL <= 1997.99) else 165.2 if (SL >= 1998 and SL <= 2013.99) else 167.75 if (SL >= 2014 and SL <= 2029.99) else 170.35 if (SL >= 2030 and SL <= 2045.99) else 172.9 if (SL >= 2046 and SL <= 2061.99) else 175.5 if (SL >= 2062 and SL <= 2077.99) else 178.1 if (SL >= 2078 and SL <= 2093.99) else 180.65 if (SL >= 2094 and SL <= 2109.99) else 183.25 if (SL >= 2110 and SL <= 2125.99) else 185.8 if (SL >= 2126 and SL <= 2141.99) else 188.4 if (SL >= 2142 and SL <= 2157.99) else 191.65 if (SL >= 2158 and SL <= 2181.99) else 195.55 if (SL >= 2182 and SL <= 2205.99) else 199.45 if (SL >= 2206 and SL <= 2229.99) else 203.35 if (SL >= 2230 and SL <= 2253.99) else 207.3 if (SL >= 2254 and SL <= 2277.99) else 211.2 if (SL >= 2278 and SL <= 2301.99) else 215.1 if (SL >= 2302 and SL <= 2325.99) else 219.05 if (SL >= 2326 and SL <= 2349.99) else 222.95 if (SL >= 2350 and SL <= 2373.99) else 227 if (SL >= 2374 and SL <= 2397.99) else 231.1 if (SL >= 2398 and SL <= 2421.99) else 235.2 if (SL >= 2422 and SL <= 2445.99) else 239.25 if (SL >= 2446 and SL <= 2469.99) else 243.35 if (SL >= 2470 and SL <= 2493.99) else 247.45 if (SL >= 2494 and SL <= 2517.99) else 251.55 if (SL >= 2518 and SL <= 2541.99) else 255.65 if (SL >= 2542 and SL <= 2565.99) else 259.75 if (SL >= 2566 and SL <= 2589.99) else 263.85 if (SL >= 2590 and SL <= 2613.99) else 267.95 if (SL >= 2614 and SL <= 2637.99) else 272 if (SL >= 2638 and SL <= 2661.99) else 276.1 if (SL >= 2662 and SL <= 2685.99) else 280.2 if (SL >= 2686 and SL <= 2709.99) else 284.3 if (SL >= 2710 and SL <= 2733.99) else 288.4 if (SL >= 2734 and SL <= 2757.99) else 292.5 if (SL >= 2758 and SL <= 2781.99) else 296.6 if (SL >= 2782 and SL <= 2805.99) else 300.65 if (SL >= 2806 and SL <= 2829.99) else 304.75 if (SL >= 2830 and SL <= 2853.99) else 308.85 if (SL >= 2854 and SL <= 2877.99) else 312.95 if (SL >= 2878 and SL <= 2901.99) else 317.05 if (SL >= 2902 and SL <= 2925.99) else 321.15 if (SL >= 2926 and SL <= 2949.99) else 325.25 if (SL >= 2950 and SL <= 2973.99) else 329.35 if (SL >= 2974 and SL <= 2997.99) else 333.4 if (SL >= 2998 and SL <= 3021.99) else 337.5 if (SL >= 3022 and SL <= 3045.99) else 341.6 if (SL >= 3046 and SL <= 3069.99) else 345.7 if (SL >= 3070 and SL <= 3093.99) else 349.8 if (SL >= 3094 and SL <= 3117.99) else 353.9 if (SL >= 3118 and SL <= 3141.99) else 358 if (SL >= 3142 and SL <= 3165.99) else 362.05 if (SL >= 3166 and SL <= 3189.99) else 366.15 if (SL >= 3190 and SL <= 3213.99) else 370.25 if (SL >= 3214 and SL <= 3237.99) else 374.4 if (SL >= 3238 and SL <= 3261.99) else 378.5 if (SL >= 3262 and SL <= 3285.99) else 382.6 if (SL >= 3286 and SL <= 3309.99) else 386.7 if (SL >= 3310 and SL <= 3333.99) else 390.8 if (SL >= 3334 and SL <= 3357.99) else 394.9 if (SL >= 3358 and SL <= 3381.99) else 399.05 if (SL >= 3382 and SL <= 3405.99) else 403.15 if (SL >= 3406 and SL <= 3429.99) else 407.25 if (SL >= 3430 and SL <= 3453.99) else 411.35 if (SL >= 3454 and SL <= 3477.99) else 416.15 if (SL >= 3478 and SL <= 3509.99) else 421.6 if (SL >= 3510 and SL <= 3541.99) else 427.1 if (SL >= 3542 and SL <= 3573.99) else 432.6 if (SL >= 3574 and SL <= 3605.99) else 438.05 if (SL >= 3606 and SL <= 3637.99) else 443.55 if (SL >= 3638 and SL <= 3669.99) else 449 if (SL >= 3670 and SL <= 3701.99) else 454.5 if (SL >= 3702 and SL <= 3733.99) else 459.95 if (SL >= 3734 and SL <= 3765.99) else 465.95 if (SL >= 3766 and SL <= 3797.99) else 472.9 if (SL >= 3798 and SL <= 3829.99) else 479.85 if (SL >= 3830 and SL <= 3861.99) else 486.8 if (SL >= 3862 and SL <= 3893.99) else 493.75 if (SL >= 3894 and SL <= 3925.99) else 500.7 if (SL >= 3926 and SL <= 3957.99) else 507.65 if (SL >= 3958 and SL <= 3989.99) else 514.6 if (SL >= 3990 and SL <= 4021.99) else 521.55 if (SL >= 4022 and SL <= 4053.99) else 528.5 if (SL >= 4054 and SL <= 4085.99) else 535.45 if (SL >= 4086 and SL <= 4117.99) else 542.4 if (SL >= 4118 and SL <= 4149.99) else 549.35 if (SL >= 4150 and SL <= 4181.99) else 556.3 if (SL >= 4182 and SL <= 4213.99) else 563.25 if (SL >= 4214 and SL <= 4245.99) else 570.15 if (SL >= 4246 and SL <= 4277.99) else 577.1 if (SL >= 4278 and SL <= 4309.99) else 584.05 if (SL >= 4310 and SL <= 4341.99) else 591 if (SL >= 4342 and SL <= 4373.99) else 597.95 if (SL >= 4374 and SL <= 4405.99) else 604.9 if (SL >= 4406 and SL <= 4437.99) else 611.85 if (SL >= 4438 and SL <= 4469.99) else 618.8 if (SL >= 4470 and SL <= 4501.99) else 625.75 if (SL >= 4502 and SL <= 4533.99) else 632.7 if (SL >= 4534 and SL <= 4565.99) else 639.65 if (SL >= 4566 and SL <= 4597.99) else 646.6 if (SL >= 4598 and SL <= 4629.99) else 653.55 if (SL >= 4630 and SL <= 4661.99) else 660.5 if (SL >= 4662 and SL <= 4693.99) else 667.45 if (SL >= 4694 and SL <= 4725.99) else 674.4 if (SL >= 4726 and SL <= 4757.99) else 681.35 if (SL >= 4758 and SL <= 4789.99) else 688.3 if (SL >= 4790 and SL <= 4821.99) else 695.2 if (SL >= 4822 and SL <= 4853.99) else 702.15 if (SL >= 4854 and SL <= 4885.99) else 709.1 if (SL >= 4886 and SL <= 4917.99) else 716.05 if (SL >= 4918 and SL <= 4949.99) else 723 if (SL >= 4950 and SL <= 4981.99) else 729.95 if (SL >= 4982 and SL <= 5013.99) else 736.9 if (SL >= 5014 and SL <= 5045.99) else 743.85 if (SL >= 5046 and SL <= 5077.99) else 750.8 if (SL >= 5078 and SL <= 5109.99) else 757.75 if (SL >= 5110 and SL <= 5141.99) else 764.7 if (SL >= 5142 and SL <= 5173.99) else 771.65 if (SL >= 5174 and SL <= 5205.99) else 778.6 if (SL >= 5206 and SL <= 5237.99) else 786.4 if (SL >= 5238 and SL <= 5277.99) else 795.1 if (SL >= 5278 and SL <= 5317.99) else 803.75 if (SL >= 5318 and SL <= 5357.99) else 812.45 if (SL >= 5358 and SL <= 5397.99) else 821.15 if (SL >= 5398 and SL <= 5437.99) else 829.8 if (SL >= 5438 and SL <= 5477.99) else 838.5 if (SL >= 5478 and SL <= 5517.99) else 847.2 if (SL >= 5518 and SL <= 5557.99) else 855.9 if (SL >= 5558 and SL <= 5597.99) else 864.55 if (SL >= 5598 and SL <= 5637.99) else 873.25 if (SL >= 5638 and SL <= 5677.99) else 881.95 if (SL >= 5678 and SL <= 5717.99) else 890.6 if (SL >= 5718 and SL <= 5757.99) else 899.3 if (SL >= 5758 and SL <= 5797.99) else 908 if (SL >= 5798 and SL <= 5837.99) else 917 if (SL >= 5838 and SL <= 5877.99) else 926.8 if (SL >= 5878 and SL <= 5917.99) else 936.6 if (SL >= 5918 and SL <= 5957.99) else 946.4 if (SL >= 5958 and SL <= 5997.99) else 956.15 if (SL >= 5998 and SL <= 6037.99) else 965.95 if (SL >= 6038 and SL <= 6077.99) else 975.75 if (SL >= 6078 and SL <= 6117.99) else 985.55 if (SL >= 6118 and SL <= 6157.99) else 995.35 if (SL >= 6158 and SL <= 6197.99) else 1005.15 if (SL >= 6198 and SL <= 6237.99) else 1014.95 if (SL >= 6238 and SL <= 6277.99) else 1024.75 if (SL >= 6278 and SL <= 6317.99) else 1034.5 if (SL >= 6318 and SL <= 6357.99) else 1044.3 if (SL >= 6358 and SL <= 6397.99) else 1054.1 if (SL >= 6398 and SL <= 6437.99) else 1063.9 if (SL >= 6438 and SL <= 6477.99) else 1073.7 if (SL >= 6478 and SL <= 6517.99) else 1083.5 if (SL >= 6518 and SL <= 6557.99) else 1093.3 if (SL >= 6558 and SL <= 6597.99) else 1103.1 if (SL >= 6598 and SL <= 6637.99) else 1112.85 if (SL >= 6638 and SL <= 6677.99) else 1122.65 if (SL >= 6678 and SL <= 6717.99) else 1132.45 if (SL >= 6718 and SL <= 6757.99) else 1142.25 if (SL >= 6758 and SL <= 6797.99) else 1152.05 if (SL >= 6798 and SL <= 6837.99) else 1161.85 if (SL >= 6838 and SL <= 6877.99) else 1171.65 if (SL >= 6878 and SL <= 6917.99) else 1181.4 if (SL >= 6918 and SL <= 6957.99) else 1191.2 if (SL >= 6958 and SL <= 6997.99) else 1201 if (SL >= 6998 and SL <= 7037.99) else 1210.8 if (SL >= 7038 and SL <= 7077.99) else 1220.6 if (SL >= 7078 and SL <= 7117.99) else 1230.4 if (SL >= 7118 and SL <= 7157.99) else 1240.2 if (SL >= 7158 and SL <= 7197.99) else 1250 if (SL >= 7198 and SL <= 7237.99) else 1259.75 if (SL >= 7238 and SL <= 7277.99) else 1269.55 if (SL >= 7278 and SL <= 7317.99) else 1279.35 if (SL >= 7318 and SL <= 7357.99) else 1289.15 if (SL >= 7358 and SL <= 7397.99) else 1298.95 if (SL >= 7398 and SL <= 7437.99) else 1309.7 if (SL >= 7438 and SL <= 7485.99) else 1321.45 if (SL >= 7486 and SL <= 7533.99) else 1333.25 if (SL >= 7534 and SL <= 7581.99) else 1345 if (SL >= 7582 and SL <= 7629.99) else 1356.75 if (SL >= 7630 and SL <= 7677.99) else 1368.5 if (SL >= 7678 and SL <= 7725.99) else 1380.25 if (SL >= 7726 and SL <= 7773.99) else 1392 if (SL >= 7774 and SL <= 7821.99) else 1403.75 if (SL >= 7822 and SL <= 7869.99) else 1415.5 if (SL >= 7870 and SL <= 7917.99) else 1427.25 if (SL >= 7918 and SL <= 7965.99) else 1439 if (SL >= 7966 and SL <= 8013.99) else 1450.75 if (SL >= 8014 and SL <= 8061.99) else 1462.5 if (SL >= 8062 and SL <= 8109.99) else 1474.25 if (SL >= 8110 and SL <= 8157.99) else 1486 if (SL >= 8158 and SL <= 8205.99) else 1497.75 if (SL >= 8206 and SL <= 8253.99) else 1509.5 if (SL >= 8254 and SL <= 8301.99) else 1521.25 if (SL >= 8302 and SL <= 8349.99) else 1534.45 if (SL >= 8350 and SL <= 8397.99) else 1547.7 if (SL >= 8398 and SL <= 8445.99) else 1560.9 if (SL >= 8446 and SL <= 8493.99) else 1574.15 if (SL >= 8494 and SL <= 8541.99) else 1587.35 if (SL >= 8542 and SL <= 8589.99) else 1600.6 if (SL >= 8590 and SL <= 8637.99) else 1613.8 if (SL >= 8638 and SL <= 8685.99) else 1627.05 if (SL >= 8686 and SL <= 8733.99) else 1640.3 if (SL >= 8734 and SL <= 8781.99) else 1653.5 if (SL >= 8782 and SL <= 8829.99) else 1666.75 if (SL >= 8830 and SL <= 8877.99) else 1679.95 if (SL >= 8878 and SL <= 8925.99) else 1693.2 if (SL >= 8926 and SL <= 8973.99) else 1706.4 if (SL >= 8974 and SL <= 9021.99) else 1719.65 if (SL >= 9022 and SL <= 9069.99) else 1732.85 if (SL >= 9070 and SL <= 9117.99) else 1746.1 if (SL >= 9118 and SL <= 9165.99) else 1759.3 if (SL >= 9166 and SL <= 9213.99) else 1772.55 if (SL >= 9214 and SL <= 9261.99) else 1785.75 if (SL >= 9262 and SL <= 9309.99) else 1799 if (SL >= 9310 and SL <= 9357.99) else 1812.2 if (SL >= 9358 and SL <= 9405.99) else 1825.45 if (SL >= 9406 and SL <= 9453.99) else 1838.65 if (SL >= 9454 and SL <= 9501.99) else 1851.9 if (SL >= 9502 and SL <= 9549.99) else 1865.1 if (SL >= 9550 and SL <= 9597.99) else 1878.35 if (SL >= 9598 and SL <= 9645.99) else 1891.6 if (SL >= 9646 and SL <= 9693.99) else 1904.8 if (SL >= 9694 and SL <= 9741.99) else 1918.05 if (SL >= 9742 and SL <= 9789.99) else 1931.25 if (SL >= 9790 and SL <= 9837.99) else 1944.5 if (SL >= 9838 and SL <= 9885.99) else 1957.7 if (SL >= 9886 and SL <= 9933.99) else 1970.95 if (SL >= 9934 and SL <= 9981.99) else 1984.15 if (SL >= 9982 and SL <= 10029.99) else 1997.4

And here is provincial tax (Québec province) :

0 if (SL >= 0 and SL <= 649.99) else 1.62 if (SL >= 650 and SL <= 659.99) else 3.03 if (SL >= 660 and SL <= 669.99) else 4.44 if (SL >= 670 and SL <= 679.99) else 5.85 if (SL >= 680 and SL <= 689.99) else 7.26 if (SL >= 690 and SL <= 699.99) else 8.67 if (SL >= 700 and SL <= 709.99) else 10.08 if (SL >= 710 and SL <= 719.99) else 11.49 if (SL >= 720 and SL <= 729.99) else 12.9 if (SL >= 730 and SL <= 739.99) else 14.31 if (SL >= 740 and SL <= 749.99) else 15.72 if (SL >= 750 and SL <= 759.99) else 17.13 if (SL >= 760 and SL <= 769.99) else 18.56 if (SL >= 770 and SL <= 779.99) else 20.06 if (SL >= 780 and SL <= 789.99) else 21.56 if (SL >= 790 and SL <= 799.99) else 23.06 if (SL >= 800 and SL <= 809.99) else 24.56 if (SL >= 810 and SL <= 819.99) else 26.06 if (SL >= 820 and SL <= 829.99) else 27.56 if (SL >= 830 and SL <= 839.99) else 29.06 if (SL >= 840 and SL <= 849.99) else 30.56 if (SL >= 850 and SL <= 859.99) else 32.81 if (SL >= 860 and SL <= 879.99) else 35.81 if (SL >= 880 and SL <= 899.99) else 38.81 if (SL >= 900 and SL <= 919.99) else 41.81 if (SL >= 920 and SL <= 939.99) else 44.81 if (SL >= 940 and SL <= 959.99) else 47.81 if (SL >= 960 and SL <= 979.99) else 50.81 if (SL >= 980 and SL <= 999.99) else 53.81 if (SL >= 1000.00 and SL <= 1019.99) else 56.81 if (SL >= 1020.00 and SL <= 1039.99) else 59.81 if (SL >= 1040.00 and SL <= 1059.99) else 62.81 if (SL >= 1060.00 and SL <= 1079.99) else 65.81 if (SL >= 1080.00 and SL <= 1099.99) else 68.81 if (SL >= 1100.00 and SL <= 1119.99) else 71.81 if (SL >= 1120.00 and SL <= 1139.99) else 74.81 if (SL >= 1140.00 and SL <= 1159.99) else 77.81 if (SL >= 1160.00 and SL <= 1179.99) else 80.81 if (SL >= 1180.00 and SL <= 1199.99) else 83.81 if (SL >= 1200.00 and SL <= 1219.99) else 86.81 if (SL >= 1220.00 and SL <= 1239.99) else 89.81 if (SL >= 1240.00 and SL <= 1259.99) else 92.81 if (SL >= 1260.00 and SL <= 1279.99) else 95.81 if (SL >= 1280.00 and SL <= 1299.99) else 98.81 if (SL >= 1300.00 and SL <= 1319.99) else 101.81 if (SL >= 1320.00 and SL <= 1339.99) else 104.81 if (SL >= 1340.00 and SL <= 1359.99) else 107.81 if (SL >= 1360.00 and SL <= 1379.99) else 110.81 if (SL >= 1380.00 and SL <= 1399.99) else 113.81 if (SL >= 1400.00 and SL <= 1419.99) else 116.81 if (SL >= 1420.00 and SL <= 1439.99) else 119.81 if (SL >= 1440.00 and SL <= 1459.99) else 122.81 if (SL >= 1460.00 and SL <= 1479.99) else 125.81 if (SL >= 1480.00 and SL <= 1499.99) else 128.81 if (SL >= 1500.00 and SL <= 1519.99) else 131.81 if (SL >= 1520.00 and SL <= 1539.99) else 134.81 if (SL >= 1540.00 and SL <= 1559.99) else 137.81 if (SL >= 1560.00 and SL <= 1579.99) else 140.81 if (SL >= 1580.00 and SL <= 1599.99) else 143.81 if (SL >= 1600.00 and SL <= 1619.99) else 146.81 if (SL >= 1620.00 and SL <= 1639.99) else 149.81 if (SL >= 1640.00 and SL <= 1659.99) else 152.81 if (SL >= 1660.00 and SL <= 1679.99) else 155.81 if (SL >= 1680.00 and SL <= 1699.99) else 158.81 if (SL >= 1700.00 and SL <= 1719.99) else 161.81 if (SL >= 1720.00 and SL <= 1739.99) else 164.81 if (SL >= 1740.00 and SL <= 1759.99) else 167.81 if (SL >= 1760.00 and SL <= 1779.99) else 171.25 if (SL >= 1780.00 and SL <= 1799.99) else 175.25 if (SL >= 1800.00 and SL <= 1819.99) else 179.25 if (SL >= 1820.00 and SL <= 1839.99) else 183.25 if (SL >= 1840.00 and SL <= 1859.99) else 187.25 if (SL >= 1860.00 and SL <= 1879.99) else 191.25 if (SL >= 1880.00 and SL <= 1899.99) else 195.25 if (SL >= 1900.00 and SL <= 1919.99) else 199.25 if (SL >= 1920.00 and SL <= 1939.99) else 203.25 if (SL >= 1940.00 and SL <= 1959.99) else 207.25 if (SL >= 1960.00 and SL <= 1979.99) else 211.25 if (SL >= 1980.00 and SL <= 1999.99) else 215.25 if (SL >= 2000.00 and SL <= 2019.99) else 219.25 if (SL >= 2020.00 and SL <= 2039.99) else 223.25 if (SL >= 2040.00 and SL <= 2059.99) else 227.25 if (SL >= 2060.00 and SL <= 2079.99) else 231.25 if (SL >= 2080.00 and SL <= 2099.99) else 235.25 if (SL >= 2100.00 and SL <= 2119.99) else 239.25 if (SL >= 2120.00 and SL <= 2139.99) else 243.25 if (SL >= 2140.00 and SL <= 2159.99) else 247.25 if (SL >= 2160.00 and SL <= 2179.99) else 251.25 if (SL >= 2180.00 and SL <= 2199.99) else 255.25 if (SL >= 2200.00 and SL <= 2219.99) else 259.25 if (SL >= 2220.00 and SL <= 2239.99) else 263.25 if (SL >= 2240.00 and SL <= 2259.99) else 267.25 if (SL >= 2260.00 and SL <= 2279.99) else 271.25 if (SL >= 2280.00 and SL <= 2299.99) else 275.25 if (SL >= 2300.00 and SL <= 2319.99) else 279.25 if (SL >= 2320.00 and SL <= 2339.99) else 283.25 if (SL >= 2340.00 and SL <= 2359.99) else 287.25 if (SL >= 2360.00 and SL <= 2379.99) else 291.25 if (SL >= 2380.00 and SL <= 2399.99) else 295.25 if (SL >= 2400.00 and SL <= 2419.99) else 299.25 if (SL >= 2420.00 and SL <= 2439.99) else 303.25 if (SL >= 2440.00 and SL <= 2459.99) else 309.25 if (SL >= 2460.00 and SL <= 2499.99) else 317.25 if (SL >= 2500.00 and SL <= 2539.99) else 325.25 if (SL >= 2540.00 and SL <= 2579.99) else 333.25 if (SL >= 2580.00 and SL <= 2619.99) else 341.25 if (SL >= 2620.00 and SL <= 2659.99) else 349.25 if (SL >= 2660.00 and SL <= 2699.99) else 357.25 if (SL >= 2700.00 and SL <= 2739.99) else 365.25 if (SL >= 2740.00 and SL <= 2779.99) else 373.25 if (SL >= 2780.00 and SL <= 2819.99) else 381.25 if (SL >= 2820.00 and SL <= 2859.99) else 389.25 if (SL >= 2860.00 and SL <= 2899.99) else 397.25 if (SL >= 2900.00 and SL <= 2939.99) else 405.25 if (SL >= 2940.00 and SL <= 2979.99) else 413.25 if (SL >= 2980.00 and SL <= 3019.99) else 421.25 if (SL >= 3020.00 and SL <= 3059.99) else 429.25 if (SL >= 3060.00 and SL <= 3099.99) else 437.25 if (SL >= 3100.00 and SL <= 3139.99) else 445.25 if (SL >= 3140.00 and SL <= 3179.99) else 453.25 if (SL >= 3180.00 and SL <= 3219.99) else 461.25 if (SL >= 3220.00 and SL <= 3259.99) else 469.25 if (SL >= 3260.00 and SL <= 3299.99) else 477.25 if (SL >= 3300.00 and SL <= 3339.99) else 485.25 if (SL >= 3340.00 and SL <= 3379.99) else 493.25 if (SL >= 3380.00 and SL <= 3419.99) else 501.25 if (SL >= 3420.00 and SL <= 3459.99) else 509.25 if (SL >= 3460.00 and SL <= 3499.99) else 517.43 if (SL >= 3500.00 and SL <= 3539.99) else 527.03 if (SL >= 3540.00 and SL <= 3579.99) else 536.63 if (SL >= 3580.00 and SL <= 3619.99) else 546.23 if (SL >= 3620.00 and SL <= 3659.99) else 555.83 if (SL >= 3660.00 and SL <= 3699.99) else 565.43 if (SL >= 3700.00 and SL <= 3739.99) else 575.03 if (SL >= 3740.00 and SL <= 3779.99) else 584.63 if (SL >= 3780.00 and SL <= 3819.99) else 594.23 if (SL >= 3820.00 and SL <= 3859.99) else 603.83 if (SL >= 3860.00 and SL <= 3899.99) else 613.43 if (SL >= 3900.00 and SL <= 3939.99) else 623.03 if (SL >= 3940.00 and SL <= 3979.99) else 632.63 if (SL >= 3980.00 and SL <= 4019.99) else 642.23 if (SL >= 4020.00 and SL <= 4059.99) else 656.63 if (SL >= 4060.00 and SL <= 4139.99) else 675.83 if (SL >= 4140.00 and SL <= 4219.99) else 695.03 if (SL >= 4220.00 and SL <= 4299.99) else 715.49 if (SL >= 4300.00 and SL <= 4379.99) else 736.09 if (SL >= 4380.00 and SL <= 4459.99) else 756.69 if (SL >= 4460.00 and SL <= 4539.99) else 777.29 if (SL >= 4540.00 and SL <= 4619.99) else 797.89 if (SL >= 4620.00 and SL <= 4699.99) else 818.49 if (SL >= 4700.00 and SL <= 4779.99) else 839.09 if (SL >= 4780.00 and SL <= 4859.99) else 859.69 if (SL >= 4860.00 and SL <= 4939.99) else 880.29 if (SL >= 4940.00 and SL <= 5019.99) else 900.89 if (SL >= 5020.00 and SL <= 5099.99) else 921.49 if (SL >= 5100.00 and SL <= 5179.99) else 942.09 if (SL >= 5180.00 and SL <= 5259.99) else 962.69 if (SL >= 5260.00 and SL <= 5339.99) else 983.29 if (SL >= 5340.00 and SL <= 5419.99) else 1003.89 if (SL >= 5420.00 and SL <= 5499.99) else 1024.49 if (SL >= 5500.00 and SL <= 5579.99) else 1045.09 if (SL >= 5580.00 and SL <= 5659.99) else 1065.69 if (SL >= 5660.00 and SL <= 5739.99) else 1086.29 if (SL >= 5740.00 and SL <= 5819.99) else 1106.89 if (SL >= 5820.00 and SL <= 5899.99) else 1127.49 if (SL >= 5900.00 and SL <= 5979.99) else 1148.09 if (SL >= 5980.00 and SL <= 6059.99) else 1168.69 if (SL >= 6060.00 and SL <= 6139.99) else 1189.29 if (SL >= 6140.00 and SL <= 6219.99) else 1209.89 if (SL >= 6220.00 and SL <= 6299.99) else 1230.49 if (SL >= 6300.00 and SL <= 6379.99) else 1251.09 if (SL >= 6380.00 and SL <= 6459.99) else 1271.69 if (SL >= 6460.00 and SL <= 6539.99) else 1292.29 if (SL >= 6540.00 and SL <= 6619.99) else 1312.89 if (SL >= 6620.00 and SL <= 6699.99) else 1333.49 if (SL >= 6700.00 and SL <= 6779.99) else 1354.09 if (SL >= 6780.00 and SL <= 6859.99) else 1374.69 if (SL >= 6860.00 and SL <= 6939.99) else 1395.29 if (SL >= 6940.00 and SL <= 7019.99) else 1415.89 if (SL >= 7020.00 and SL <= 7099.99) else 1436.49 if (SL >= 7100.00 and SL <= 7179.99) else 1457.09

4 Likes

Good lord… how complex can it be?

We in South Africa only have National VAT and PAYE tax, which requires similar treatment. Thanks for sharing.

hahaha yes it is a nightmare!

We have been using the online calculator. This will save us some manual entry. Thank you!

thank you man :slight_smile: it really helped me to get the syntax of if else

You are welcome :slight_smile:

1 Like