Hi MZ,
To calculate a person's taxable income using the six different marginal tax rates, you can use the
nested IF function. Here's an example formula that you can use:
- =IF(D36<=8350,D36*0.1,
- IF(D36<=33950,(D36-8350)*0.15+835,
- IF(D36<=82250,(D36-33950)*0.25+4675,
- IF(D36<=171550,(D36-82250)*0.28+4675+12000,
- IF(D36<=372950,(D36-171550)*0.33+4675+12000+15087.6,
- (D36-372950)*0.35+4675+12000+15087.6+93619.5)))))
This formula checks the income amount against each marginal tax rate and calculates the tax amount accordingly. The
IF function is nested, meaning that there are multiple IF statements within each other.
To answer your second question, yes, you can convert a percentage to a fraction by dividing it by 100. For example, 15% is equal to 0.15 as a decimal or 15/100 as a fraction.