Title: Default Value Calculated fields
Last modified: August 14, 2023

---

# Default Value Calculated fields

 *  Resolved [tosh11formula](https://wordpress.org/support/users/tosh11formula/)
 * (@tosh11formula)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/default-value-calculated-fields/)
 * Hello
 * Hi It is possible to have a default value in “Calculated fields” if the value
   is invalid instead of 0 value?
 * `Filedname8: PREC(fieldname2*_fieldname6_*fieldname7/1000000,2)
   Example Result:
   X.XX
 * I have to 2 Decimal value in the end, some of the user put lowest value but the
   result if showing 0 value
 * `and for final Result
   Fieldname9: ROUND(fieldname8*9500,true)
    – We Want to Default
   Value example 9,500 instead of 0 in this field.
 * is this possible?
    -  This topic was modified 2 years, 10 months ago by [tosh11formula](https://wordpress.org/support/users/tosh11formula/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdefault-value-calculated-fields%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/default-value-calculated-fields/#post-16970461)
 * Hello [@tosh11formula](https://wordpress.org/support/users/tosh11formula/)
 * Yes, that’s possible.
 * Assuming you want to check if fieldname8 is different from zero before evaluating
   the mathematical operation (fieldname8*9500) and display 9500 otherwise.
 * In this case, you need a conditional operation as follows:
 *     ```wp-block-code
       ROUND(IF(fieldname8, fieldname8*9500, 9500))
       ```
   
 * Best regards.
 *  Thread Starter [tosh11formula](https://wordpress.org/support/users/tosh11formula/)
 * (@tosh11formula)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/default-value-calculated-fields/#post-16970541)
 * Thank you on this,
 * Anyway, it is also possible the value on `Fields` is 3 characters only,
 * for example: allowed for field is max 999, they not allowed to input more characters,
   is this also possible?
 * ![](https://i0.wp.com/importstation.ph/wp-content/uploads/2023/08/dddd.jpg?ssl
   =1)
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/default-value-calculated-fields/#post-16970563)
 * Hello [@tosh11formula](https://wordpress.org/support/users/tosh11formula/)
 * You can enter the 999 through the max attribute in the field’s settings. The 
   plugin will allow users to type larger numbers, but it will display a validation
   error.
 * In the equation that uses the field you can use conditional operations to not
   evaluate it if the operands values are incorrect.
 * Ex.
 *     ```wp-block-code
       IF(AND(fieldname2<=999, fieldname6<=999, fieldname7<=999),PREC(fieldname2*fieldname6*fieldname7/1000000, 2), '')
       ```
   
 * Best regards.
 *  Thread Starter [tosh11formula](https://wordpress.org/support/users/tosh11formula/)
 * (@tosh11formula)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/default-value-calculated-fields/#post-16970674)
 * Great, Thank you for your help

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

The topic ‘Default Value Calculated fields’ 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/)

 * 4 replies
 * 2 participants
 * Last reply from: [tosh11formula](https://wordpress.org/support/users/tosh11formula/)
 * Last activity: [2 years, 10 months ago](https://wordpress.org/support/topic/default-value-calculated-fields/#post-16970674)
 * Status: resolved