Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need Urgent help with this please. Also, the project needs to use formula which should be viewable to anything on the fx box. The
I need Urgent help with this please. Also, the project needs to use formula which should be viewable to anything on the fx box. The questions are mentiomed on the picture. Thanks a lot in advance.
Home Insert Page Layout Formulas Review View Data Connections Az T Show Deta Properties t Sort Filte Advanced ext to Remove Data Consolidate What lif Group Ungroup Subtotal e Hide Detail Columns Duplicates Val dat Analysis tion From From From New Database Refresh Edit Links FileMaker HTML Text Query 11 Name salary Tax Rate |Tax Amount 1 Tax Table smithi 54,000 Salary Tax 4 J. Smith 65,000 J. Smith 3 37,000 Rate 30,000 6 J. Smith 4 40,000 44,000 7 J. Smith 62,000 50,000 42,000 8 J. Smith 6 60,000 J. Smith 7 31,000 10 J. Smith 8 88,000 70,000 80,000 13 11 J. Smith9 91,000 90,000 14 12 J. Smith 10 52,000 100,000 15 15 TOTAL TAX AMOUNT 18 1. USE the vlookup function to find the appropriate Tax-Rate (in the Tax Table) for each employee 19 2. Calculate the individual Tax-Amount 20 3. Get the TOTAL TAXAMOUNT of all Tax-Amounts 21 4. Use Solver to increase the TOTAL TAX AMOUNT 65,000, and use the appropriate STEP 1 ShareStep 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