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

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: