Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write an IF/IFS statement to calculate the tax rates for the following persons working with XYZ Inc. Name Filing Status Salary Tax Rate Brian Kramer
| Write an IF/IFS statement to calculate the tax rates for the following persons working with XYZ Inc. |
| Name | Filing Status | Salary | Tax Rate |
| Brian Kramer | Married Filing Jointly | 76924 | |
| Cole Smith | Married Filing Jointly | 350000 | |
| Rachel Sanders | Married Filing Jointly | 72856 | |
| Young Yu | Married Filing Jointly | 165500 | |
| Stephani Mohl | Single | 210389 | |
| Rachna Kishore | Single | 77500 | |
| Mohsen Ahmed | Single | 157500 | |
| Juli Hurt | Single | 91646 | |
| David Olson | Single | 36771 |
| Tax Bracket/Rate | Single | Married Filing Jointly | Head of Household |
| 10% | $0 - $9,525 | $0 - $19,050 | $0 - $13,600 |
| 12% | $9,526 - $38,700 | $19,051 - $77,400 | $13,601 - $51,800 |
| 22% | $38,701 - $82,500 | $77,401 - $165,000 | $51,801 - $82,500 |
| 24% | $82,501 - $157,500 | $165,001 - $315,000 | $82,501 - $157,500 |
| 32% | $157,501 - $200,000 | $315,001 - $400,000 | $157,501 - $200,000 |
| 35% | $200,001 - $500,000 | $400,001 - $600,000 | $200,001 - $500,000 |
| 37% | $500,000+ | $600,001+ | $500,000+ |
Please help me get the Tax rate by using if/ifs statement function in excel, must provide the excel function!
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
Using Financial Accounting Information The Alternative to Debits and Credits
Authors: Gary A. Porter, Curtis L. Norton
8th edition
1111534918, 978-1111534912
