Question: Please help me create excel formula for these questions. A B C D E F G H 1 Income Given Info Given Value Tax Amount

Please help me create excel formula for these questions.

Please help me create excel formula for these questions. A B CD E F G H 1 Income Given Info Given Value TaxAmount Min Tax Max Tax Sum Tax Average Tax 2 58391 Level

A B C D E F G H 1 Income Given Info Given Value Tax Amount Min Tax Max Tax Sum Tax Average Tax 2 58391 Level 1 26000 3 102925 Level 2 46000 4 13265 Tax Percent 0.14 5 20939 Tax Percent 0.24 6 12111 7 117385 8 84971 9 92755 OT 63099 11 104327 12 111670 13 79541 14 63223 15 106013 16 91055 17 93664 18 95823 Sheet1 +Excel Project 1 Please read the information below carefully This project has 2 parts: Part 1: Excel Formulas: 1. Click here to download your data. 2. You must read the tutorial from here. The tutorial explains the Nested IF function in Excel which is necessary for this project. 3. Once you completed all the calculations in Excel, save your workbook with an .xlsx extension and upload it below. 4. If you forget to upload your excel file or accidentally submit the project, you will receive 0 for the excel section of the project (you cannot send the excel file manually). 5. You must use Nested IF function to solve this project. 6. Use relative and absolute references properly inside the Nested IF: - If you choose a relative reference where an absolute reference is necessary, your answer will be wrong. 7. Pay close attention to inequality signs you use in yourNested IF (If the correct answer is "

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 Mathematics Questions!