Question: Worksheet B shows an invoice template. The template has been partially completed. In cell B 1 7 , add a function to find the sales

Worksheet B shows an invoice template. The template has been partially completed.
In cell B17, add a function to find the sales tax rate (%). The sales tax rate is determined by the state shown in the Bill To: address (cell B8). The formula should return the actual tax rate as shown in column J. For example, the tax rate for NC is 4.75%, but when the billing address is changed to SC, the tax rate is 6.00%, GA is 4.00%, etc.)
You do not need to worry about the tax-exempt status or cell G17, which will be addressed in later questions.
What is the most efficient function to determine the tax rate in cell B8?

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!