Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using VLOOKUP function, please fill up the Remarks column as follows: if the order amount is below $ 3 0 0 0 , the comment
Using VLOOKUP function, please fill up the Remarks column as follows:
if the order amount is below $ the comment is "very small"; between $ and $ the comment is "small"; between $ and $ it is "large"; more than $ it is "very large"
Fill up the FedTAX$ column in dollars.
The federal tax payable is provided in the Analysis work sheet and is payable only for order amount exceeding $ OR there is amount outstanding.
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