Title: [Plugin: Calculated Fields Form] Problem with Nested IF AND statements
Last modified: September 1, 2016

---

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

 *  [deiaemeth](https://wordpress.org/support/users/deiaemeth/)
 * (@deiaemeth)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [deiaemeth](https://wordpress.org/support/users/deiaemeth/)
 * (@deiaemeth)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-calculated-fields-form-problem-with-nested-if-and-statements/#post-7650088)
 * I’m trying something along the lines of but doesn’t seem to work…
 * =IF(fieldname2<9225,”fieldname*0.1″,IF(fieldname2<37450,”922.5+(37450-9225)*0.15″,
   IF(fieldname2<90750,”5156.25+(90750-37450)*0.25″,IF(fieldname2<189300,”18481.25
   +(189300-90750)*0.28″,IF(fieldname2<411500,”46075.25+(411500-189300)*0.33″,IF(
   fieldname2<413200,”19401.25+(413200-411500)*0.35″,”119996.25+(fieldname2-413200)*
   0.396″))))))
 * Any suggestions would be welcome 🙂
 *  Thread Starter [deiaemeth](https://wordpress.org/support/users/deiaemeth/)
 * (@deiaemeth)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-calculated-fields-form-problem-with-nested-if-and-statements/#post-7650089)
 * Sorry, meant something like this 🙂
 * IF(fieldname2<9225,fieldname2*0.1,IF(fieldname2<37450,922.5+(fieldname2-9225)*
   0.15,IF(fieldname2<90750,5156.25+(fieldname2-37450)*0.25,IF(fieldname2<189300,18481.25
   +(fieldname2-90750)*0.28,IF(fieldname2<411500,46075.25+(fieldname2-189300)*0.33,
   IF(fieldname2<413200,19401.25+(fieldname2-411500)*0.35,119996.25+(fieldname2-
   413200)*0.396))))))

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin: Calculated Fields Form] Problem with Nested IF AND statements’
is closed to new replies.

## Tags

 * [Calculated](https://wordpress.org/support/topic-tag/calculated/)
 * [Calculated fields](https://wordpress.org/support/topic-tag/calculated-fields/)
 * [tax](https://wordpress.org/support/topic-tag/tax/)

 * 2 replies
 * 1 participant
 * Last reply from: [deiaemeth](https://wordpress.org/support/users/deiaemeth/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-calculated-fields-form-problem-with-nested-if-and-statements/#post-7650089)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics