Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what excel equation would I use to solve this 1 . ( max point deduction: 1 5 ) Calculate Income tax: For the first $
what excel equation would I use to solve this max point deduction: Calculate Income tax: For the first $ no taxes are withheld. For anything above $ the amount above $ is taxed at
a Create a new column for Income Tax
b Compute income tax and place them in this column. HINT: You need an IF function here.
c Conditionally format the column such that if income tax is less than $ the cell is bold font and yellow colored text color only, NOT the fill color; if income tax is between $ and $ make the cell bold font and fill it with light blue color.
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