Forum Discussion
Brittney Arevalo
Feb 04, 2018Copper Contributor
IF function question
Hey!
I'm building a tax spreadsheet and I have a cell that needs to calculate progressive tax brackets. I need the IF statement to be built to tax the taxable income from 0 to 36250 at 15%, th...
Haytham Amairah
Feb 04, 2018Silver Contributor
Brittney,
The formula is like this:
=IF(A2>36250,(36250*15%)+((A2-36250)*28%),A2*15%)
Please find the attached file.