Title: Hide minimum value calculated field
Last modified: September 4, 2018

---

# Hide minimum value calculated field

 *  Resolved [Alwin](https://wordpress.org/support/users/wp-opti/)
 * (@wp-opti)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/hide-minimum-value-calculated-field/)
 * Can you please take a look at:
    [http://loeka.optiion.nl/canvas/](http://loeka.optiion.nl/canvas/)
 * – check the button called “Canvas compleet”
 * Now you see a price value of 34.00 and that is because I used this Equation for
   the Calculated field “Prijs Canvas compleet”.
    PREC(fieldname17*2.32+34.00,2)
 * I don’t like the fact that the minumum price of 34.00 is displayed while there
   is no input in the fields called “Korte zijde foto in cm” and “Lange zijde foto
   in cm”.
 * It would be nice if the field “Prijs Canvas compleet” would show a value of 0.00
   and only shows the calculated price when there is input in the fieldnames “Korte
   zijde foto in cm” and “Lange zijde foto in cm”.
 * To do this I need to edit the Equation for this field like this:
 * when fieldname15 and fieldname16 are emtpy then display o.oo
    when fieldname15
   and fieldname16 are each more then 20 then display the outcome of the Equation:
   PREC(fieldname17*2.32+34.00,2)
 * Is that possible?
 * Thank you,
    Alwin

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/hide-minimum-value-calculated-field/#post-10655265)
 * Hello [@wp-opti](https://wordpress.org/support/users/wp-opti/),
 * The equation in this case would be simply:
 *     ```
       PREC(IF(fieldname17, fieldname17*2.32+34, 0), 2)
       ```
   
 * Best regards.
 *  Thread Starter [Alwin](https://wordpress.org/support/users/wp-opti/)
 * (@wp-opti)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/hide-minimum-value-calculated-field/#post-10658767)
 * Thank you, that worked!
 * However, I have one other equation that need the same rule:
 * IF(AND(100>=fieldname2,200>=fieldname6),
    PREC(MAX(3.9,fieldname40*0.60+2.70),
   2), ‘Maximale maat 100x200cm’)
 * So I changend it in:
    IF(AND(100>=fieldname2,200>=fieldname6), PREC(MAX(3.9,fieldname40*
   0.60+2.70, 0) ,2), ‘Maximale maat 100x200cm’)
 * But that does not work…
 * How can i do this?
 * Thank you,
    Alwin
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/hide-minimum-value-calculated-field/#post-10658817)
 * Hello [@wp-opti](https://wordpress.org/support/users/wp-opti/),
 * The solution would be check if the values were entered, before applying the main
   logic of the equation:
 *     ```
       IF(AND(fieldname2,fieldname6), IF(AND(fieldname2<=100,fieldname6<=200),
       PREC(MAX(3.9,fieldname40*0.60+2.70),2), 'Maximale maat 100x200cm'), '')
       ```
   
 * Best regards.

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

The topic ‘Hide minimum value calculated field’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form - AI Form Builder for WordPress - Contact, Payment, Quote, Quiz & More](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

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

 * 3 replies
 * 2 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [7 years, 11 months ago](https://wordpress.org/support/topic/hide-minimum-value-calculated-field/#post-10658817)
 * Status: resolved