Spreadsheet: 804841d1668399827-how-to-get-the-value-from-a-range-of-conditions-if-and-or-deduction-ans
Sheet: Sheet2

 |  |  |  |  |  | IF SALARY RANGE |  | DEDUCT | [NAME] |  |  |  |  | [NAME]
EMPLOYEE CODE | [NAME] |  | AMOUNT | NET PAY |  | FROM | TO | THIS AMOUNT | CODE |  |  | EMPLOYEE CODE | [NAME] | CODE | AMOUNT | NET PAY
A2001 | 20137 |  |  |  |  | 9750 | 10249.99 | 860 | 1 |  |  | A2001 | 20137 | 21 | 1730 | 18407
A2002 | 24177 |  |  |  |  | 10250 | 10749.99 | 902.5 |  |  |  | A2002 | 24177 | 29 | 2070 | 22107
A2003 | 22677 |  |  |  |  | 10750 | 11249.99 | 945 |  |  |  | A2003 | 22677 | 26 | 1942.5 | 20734.5
A2004 | 19235 |  |  |  |  | 11250 | 11749.99 | 987.5 |  |  |  | A2004 | 19235 | 19 | 1645 | 17590
A2005 | 19325 |  |  |  |  | 11750 | 12249.99 | 1030 |  |  |  | A2005 | 19325 | 20 | 1687.5 | 17637.5
A2006 | 18111 |  |  |  |  | 12250 | 12749.99 | 1072.5 |  |  |  | A2006 | 18111 | 17 | 1560 | 16551
A2007 | 16335 |  |  |  |  | 12750 | 13249.99 | 1115 |  |  |  | A2007 | 16335 | 14 | 1432.5 | 14902.5
A2008 | 11303 |  |  |  |  | 13250 | 13749.99 | 1157.5 |  |  |  | A2008 | 11303 | 4 | 987.5 | 10315.5
A2009 | 11076 |  |  |  |  | 13750 | 14249.99 | 1200 |  |  |  | A2009 | 11076 | 3 | 945 | 10131
[NAME] | 10426 |  |  |  |  | 14250 | 14749.99 | 1242.5 |  |  |  | [NAME] | 10426 | 2 | 902.5 | 9523.5
A2011 | 10426 |  |  |  |  | 14750 | 15249.99 | 1305 |  |  |  | A2011 | 10426 | 2 | 902.5 | 9523.5
A2012 | 11255.14 |  |  |  |  | 15250 | 15749.99 | 1347.5 |  |  |  | A2012 | 11255.14 | 4 | 987.5 | 10267.64
A2013 | 11255.14 |  |  |  |  | 15750 | 16249.99 | 1390 |  |  |  | A2013 | 11255.14 | 4 | 987.5 | 10267.64
A2014 | 11125.14 |  |  |  |  | 16250 | 16749.99 | 1432.5 |  |  |  | A2014 | 11125.14 | 3 | 945 | 10180.14
A2015 | 11134.76 |  |  |  |  | 16750 | 17249.99 | 1475 |  |  |  | A2015 | 11134.76 | 3 | 945 | 10189.76
A2016 | 11134.76 |  |  |  |  | 17250 | 17749.99 | 1517.5 |  |  |  | A2016 | 11134.76 | 3 | 945 | 10189.76
A2017 | 10969 |  |  |  |  | 17750 | 18249.99 | 1560 |  |  |  | A2017 | 10969 | 3 | 945 | 10024
A2018 | 10926.76 |  |  |  |  | 18250 | 18749.99 | 1602.5 |  |  |  | A2018 | 10926.76 | 3 | 945 | 9981.76
A2019 | 11411.14 |  |  |  |  | 18750 | 19249.99 | 1645 |  |  |  | A2019 | 11411.14 | 4 | 987.5 | 10423.64
A2020 | 11125.14 |  |  |  |  | 19250 | 19749.99 | 1687.5 |  |  |  | A2020 | 11125.14 | 3 | 945 | 10180.14
A2021 | 11303 |  |  |  |  | 19750 | 20249.99 | 1730 |  |  |  | A2021 | 11303 | 4 | 987.5 | 10315.5
A2022 | 11303 |  |  |  |  | 20250 | 20749.99 | 1772.5 |  |  |  | A2022 | 11303 | 4 | 987.5 | 10315.5
A2023 | 11082.76 |  |  |  |  | 20750 | 21249.99 | 1815 |  |  |  | A2023 | 11082.76 | 3 | 945 | 10137.76
A2024 | 11125.14 |  |  |  |  | 21250 | 21749.99 | 1857.5 |  |  |  | A2024 | 11125.14 | 3 | 945 | 10180.14
A2025 | 11134.76 |  |  |  |  | 21750 | 22249.99 | 1900 |  |  |  | A2025 | 11134.76 | 3 | 945 | 10189.76
A2026 | 11303 |  |  |  |  | 22250 | 22749.99 | 1942.5 |  |  |  | A2026 | 11303 | 4 | 987.5 | 10315.5
A2027 | 11134.76 |  |  |  |  | 22750 | 23249.99 | 1985 |  |  |  | A2027 | 11134.76 | 3 | 945 | 10189.76
A2028 | 11134.76 |  |  |  |  | 23250 | 23749.99 | 2027.5 |  |  |  | A2028 | 11134.76 | 3 | 945 | 10189.76
A2029 | 10848.76 |  |  |  |  | 23750 | 24249.99 | 2070 |  |  |  | A2029 | 10848.76 | 3 | 945 | 9903.76
A2030 | 10426 |  |  |  |  | 24250 | 24749.99 | 2112.5 |  |  |  | A2030 | 10426 | 2 | 902.5 | 9523.5
A2031 | 11411.14 |  |  |  |  | 24750 | 500000 | 2155 |  |  |  | A2031 | 11411.14 | 4 | 987.5 | 10423.64