Spreadsheet: 851305d1701525248-looking-for-non-array-formula-to-extract-values-if-condition-is-met-hh_extract-values
Sheet: HH

Value 1 | 55880 | Extracted Value |  | Wrong
Value 2 | W-4 [2020 or Later] | Extracted Value | 27900 | Right
Value 3 | Head Of Household
Value 4 | Not Checked
Value 5 | Yes
c) Head of Household
W-4 Year | Checked/Not Checcked? | Old/New? | Filing Type | At least | But less than | The tentative amount to withhold is: | Plus this percentage | of the amount that the Adjusted Annual Wage or Payment exceed | Filing Type | Filing Type
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 0 | 12200 | 0 | 0 | 0 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 12200 | 27900 | 0 | 0.1 | 12200 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 27900 | 72050 | 1570 | 0.12 | 27900 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 72050 | 107550 | 6868 | 0.22 | 72050 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 107550 | 194300 | 14678 | 0.24 | 107550 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 194300 | 243450 | 35498 | 0.32 | 194300 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 243450 | 590300 | 51226 | 0.35 | 243450 | Head Of Household | Head Of Household
W-4 [Before 2020] | Not Checked | W-4 [Old] | Head Of Household | 590300 | 0 | 172623.5 | 0.37 | 590300 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 0 | 10400 | 0 | 0 | 0 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 10400 | 18250 | 0 | 0.1 | 10400 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 18250 | 40325 | 785 | 0.12 | 18250 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 40325 | 58075 | 3434 | 0.22 | 40325 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 58075 | 101450 | 7339 | 0.24 | 58075 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 101450 | 126025 | 17749 | 0.32 | 101450 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 126025 | 299450 | 25613 | 0.35 | 126025 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Checked | W-4 [New] | Head Of Household | 299450 | 0 | 86311.75 | 0.37 | 299450 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 0 | 12200 | 0 | 0 | 0 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 12200 | 27900 | 0 | 0.1 | 12200 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 27900 | 72050 | 1570 | 0.12 | 27900 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 72050 | 107550 | 6868 | 0.22 | 72050 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 107550 | 194300 | 14678 | 0.24 | 107550 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 194300 | 243450 | 35498 | 0.32 | 194300 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 243450 | 590300 | 51226 | 0.35 | 243450 | Head Of Household | Head Of Household
W-4 [2020 or Later] | Not Checked | W-4 [New] | Head Of Household | 590300 | 0 | 172623.5 | 0.37 | 590300 | Head Of Household | Head Of Household