[Plugin: Calculated Fields Form] Problem with Nested IF AND statements

Hello team,

Hope this email finds everyone well. I’m trying to build a lightweight federal tax bracket calculator and am having some troubles (never used the plug-in before). Any help would be greatly appreciated.

To calculated taxes, two things need to be considered – your taxable income and your filing status (4 different kinds exist). For instance, if your filing status is ‘single’ and you are making $19,000, per the table below, you’d pay 10% on the first $9,225 (which equals $922.50), then 15% on $19,000 less $9,225 (which equals $1,446.25), for a combined total of $2,388.75. This methodology scales all the way up to 39.6% tax on amounts above $413,200. I want to make a simple calculator where a user can put in his/her taxable income and choose between the 4 filing status then get their effective tax amount.

I’ve set up a simple form to date whereby fieldname=3 is your filing bracket (with values 0,1,2,3 denoting the 4 separate statuses) and fieldname=2 is the taxable income. I am having trouble setting up a nested IF AND statement that would return the correct taxable amount. Would it be better to set up 4 different hidden calculated fields for each of the 4 filing statuses so I don’t have to use an AND statement and have one visible field pull the right calculation based on the elected filing status? Is such a functionality possible in Calculated Fields?

Could anyone advise on the best way to set up such a calculator for the scenario I’ve laid out? Any help would be greatly, greatly appreciated. Thank you very much again :

Single filers
Taxable income Tax rate
$0 to $9,225 10%
$9,226 to $37,450 $922.50 plus 15% of the amount over $9,225
$37,451 to $90,750 $5,156.25 plus 25% of the amount over $37,450
$90,751 to $189,300 $18,481.25 plus 28% of the amount over $90,750
$189,301 to $411,500 $46,075.25 plus 33% of the amount over $189,300
$411,501 to $413,200 $119,401.25 plus 35% of the amount over $411,500
$413,201 or more $119,996.25 plus 39.6% of the amount over $413,200