If the city is in the GA$\_$county$\_$tax list, then the value will come from VLOOKUP, otherwise the value will come from the second argument of IFERROR, which is zero...indicating there is no city tax in situation where the city lookup returns an error.

Change the zipcode in cell B$7$ to the value $30346.$

If you have a tax rate of $1\%$ for Atlanta, then all is well. Otherwise you have a problem you must investigate and fix before moving on to Step$-$J$.$

Step$-$J$.$ Modify the tax lookup logic you just created. Add $($using the addition operator, also known as the $+$ sign$)$ the value of tax for the county.

Determining the county tax value should be done with VLOOKUP using the county name in Cell B$5$ as the lookup$\_$value and the Ga$\_$county$\_$tax worksheet for the table$-$array.

Hint: It will look something like this $=$IFERROR$($VLOOKUP$(),0)+$ VLOOKUP$()$

After completing Step$-$J$,$ what is the value in cell E$21?$

Question $11$ options:

$8\mathrm{.}00\%$

$1\mathrm{.}00\%$

$0\mathrm{.}00\%$

$7\mathrm{.}00\%$

$6\mathrm{.}00\%$

How would you type this into excel?