Title: IF Statement Help!
Last modified: August 30, 2018

---

# IF Statement Help!

 *  Resolved [aslante](https://wordpress.org/support/users/aslante/)
 * (@aslante)
 * [7 years, 9 months ago](https://wordpress.org/support/topic/if-statement-help-2/)
 * I am trying to do a nested IF function but I can’t seem to get it to work:
 * IF( fieldname7=0, “0”, IF( fieldname7<=2, (fieldname7*550+300), (fieldname7*550)))
 * I tried this in Excel and it works, so I’m not sure what is wrong.
 * Any advise will be great!
    -  This topic was modified 7 years, 9 months ago by [aslante](https://wordpress.org/support/users/aslante/).

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [7 years, 9 months ago](https://wordpress.org/support/topic/if-statement-help-2/#post-10639206)
 * Hello [@aslante](https://wordpress.org/support/users/aslante/),
 * The issue is simple, in javascript the operator for equality is the double sign:“
   ==” because the sign: “=” is used for assignment, so, the equation should be 
   fixed as follows:
 *     ```
       IF(fieldname7==0, 0, IF(fieldname7<=2, fieldname7*550+300, fieldname7*550))
       ```
   
 * I’ve removed the unnecessary parentheses and double quote symbols.
 * Best regards.
 *  Thread Starter [aslante](https://wordpress.org/support/users/aslante/)
 * (@aslante)
 * [7 years, 9 months ago](https://wordpress.org/support/topic/if-statement-help-2/#post-10639696)
 * [@codepeople](https://wordpress.org/support/users/codepeople/)
 * Works perfectly! thank you! “D

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

The topic ‘IF Statement Help!’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [aslante](https://wordpress.org/support/users/aslante/)
 * Last activity: [7 years, 9 months ago](https://wordpress.org/support/topic/if-statement-help-2/#post-10639696)
 * Status: resolved