I need help entering this if formula into an excel sheet. My pretaxable income is 192,249.67

Pre-tax income is over: But not over: Tax is: Of amount over: $0 -$50,000 15% $0 $50,000 $75,000 ($50,000*15%) + 25% $50,000 $75,000 ($50,000*15%) + (($75,000-$50,000)*25%) + 34% $75,000 Use an IF statement to calculate income tax expense. The IF statement must consider income at 3 different levels. This requires an embedded or nested IF statement, i.e., 2 IF statements in one formula.

b. The Federal income tax rates are as follows Pre-tax income is over: But not over: Tax is: Of amount over: $50,000 $75,000 15% $50,000 ($50,000*1596) $50,000 25% ($50,000*15%) + (($75,000- $50,000 *25%) + 34% $75,000 $75,000 Use an IF statement to calculate income tax expense. The IF statement must consider income at 3 different levels. This requires an embedded or nested IF statement, i.e., 2 IF statements in one formula. (Be sure to test your IF statement at different levels of income before tax-your formula needs to work at all levels.) recommend $10,000, $60,000 and $100,000. User your calculator to confirm Excel calculated the amount correctly. c