If net income is at least $15,000 and at most $35,000, taxes paid are 28% of income above $15,000,
else, If net income is less than $15,000 then taxes paid are 15% of income above $8,000.
else, If net income is greater than $35,000, taxes paid are 33% of income above $35,000
B22 is cell reference for net income
Below is my formula, what am I doing wrong?
IF(AND((B22<=15000,B22>=35000), 0.28*(B22-15000), IF(B22<15000), 0.15*(B22-8000), IF(B22>35000), 0.33*(B22-35000))
Thank you for any advice!
else, If net income is less than $15,000 then taxes paid are 15% of income above $8,000.
else, If net income is greater than $35,000, taxes paid are 33% of income above $35,000
B22 is cell reference for net income
Below is my formula, what am I doing wrong?
IF(AND((B22<=15000,B22>=35000), 0.28*(B22-15000), IF(B22<15000), 0.15*(B22-8000), IF(B22>35000), 0.33*(B22-35000))
Thank you for any advice!