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 B to the value
If you have a tax rate of for Atlanta, then all is well. Otherwise you have a problem you must investigate and fix before moving on to StepJ
StepJ 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 as the lookupvalue and the Gacountytax worksheet for the tablearray.
Hint: It will look something like this IFERRORVLOOKUP VLOOKUP
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
