Question: Change the zipcode in cell B 7 to the value 3 0 3 4 6 . If you have a tax rate of 1 %

Change the zipcode in cell B7 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 B5 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()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!