Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Go to the sheet called v&if. In cell B9, use the Vlookup function to determine the Unit Price. In cell B1, type in Shrimp and
Go to the sheet called v&if. In cell B9, use the Vlookup function to determine the Unit Price. In cell B1, type in Shrimp and check to make sure that your worksheet is working properly. Type in the other table entries, making sure that the correct price displays for each one. . Your next task is to determine the amount of sales tax, if any, that a user would pay. Cell B3 is the cell where the user indicates whether 1 (an individual does not have to pay sales tax) or (an individual must pay sales tax). The only way that no sales tax is to be paid is if the user enters in a "1". If any other number (other than a 1) is entered into cell B3, then sales tax must be paid. What you are doing is planning for the user making an error in a business application where sales tax is being determined, it will be very costly to YOU if the appropriate amount of tax is not collected since you will have to make-up the difference. Therefore, your application should only NOT calculate sales tax if a 1 is entered. ALL OTHER NUMBER
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