Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If the city is in the GA _ county _ tax list, then the value will come from VLOOKUP, otherwise the value will come from
If the city is in the GAcountytax 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 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
After completing StepJ what is the value in cell E
Question options:
Can you type out the function?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started