Title: Does not recognize formulas
Last modified: March 9, 2021

---

# Does not recognize formulas

 *  Resolved [agendadvogado](https://wordpress.org/support/users/agendadvogado/)
 * (@agendadvogado)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/does-not-recognize-formulas/)
 * I am inserting the formula below. However, when entering the information, only
   the first three formulas are being recognized. For example: if I enter a value
   greater than 3,500, the calculation uses the percentage of 7.5% when it should
   be 15%. Can someone help me please?
    Thanks!
 *     ```
       (function(){
               if(fieldname1 <= 1903.98) return fieldname1*0;
               if(fieldname1 >= 1903.99) return fieldname1*7.5/100-142.80;
               if(fieldname1 <= 2826.65) return fieldname1*7.5/100-142.80;
               if(fieldname1 >= 2826.66) return fieldname1*15.0/100-354.80;
               if(fieldname1 <= 3751.05) return fieldname1*15.0/100-354.80;
               if(fieldname1 >= 3751.06) return fieldname1*22.5/100-636.13;
               if(fieldname1 <= 4664.68) return fieldname1*22.5/100-636.13;
               if(fieldname1 >= 4664.69) return fieldname1*27.5/100-869.36;
               })();
       ```
   
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdoes-not-recognize-formulas%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/does-not-recognize-formulas/#post-14157070)
 * Hello [@agendadvogado](https://wordpress.org/support/users/agendadvogado/)
 * The first pair of conditions covers all the possible variants:
 *     ```
       if(fieldname1 <= 1903.98) return fieldname1*0;
       if(fieldname1 >= 1903.99) return fieldname1*7.5/100-142.80;       
       ```
   
 * So, the other conditions are never reached.
 * The order matters. The correct equation would be:
 *     ```
       (function () {
           if (4664.69 <= fieldname1 ) return fieldname1 * 27.5 / 100 - 869.36;
           if (3751.06 <= fieldname1) return fieldname1 * 22.5 / 100 - 636.13;
           if (2826.66 <= fieldname1) return fieldname1 * 15.0 / 100 - 354.80;
           if (1903.99 <= fieldname1) return fieldname1 * 7.5 / 100 - 142.80;
           return 0;	
       })();
       ```
   
 * Best regards.
 *  Thread Starter [agendadvogado](https://wordpress.org/support/users/agendadvogado/)
 * (@agendadvogado)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/does-not-recognize-formulas/#post-14157279)
 * Boa tarde!
    Muito obrigado pela força!

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

The topic ‘Does not recognize formulas’ 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/)

## Tags

 * [calculation](https://wordpress.org/support/topic-tag/calculation/)
 * [formula](https://wordpress.org/support/topic-tag/formula/)
 * [percentage](https://wordpress.org/support/topic-tag/percentage/)

 * 2 replies
 * 2 participants
 * Last reply from: [agendadvogado](https://wordpress.org/support/users/agendadvogado/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/does-not-recognize-formulas/#post-14157279)
 * Status: resolved