Minimum Value to show if less than a specified figure

  • Resolved foxtucker

    (@foxtucker)


    9 years, 1 month ago

    I’m putting together an price/cost estimator for a Driveways company. I need to be able to set the minimum calculated value at 300.00 as that’s the minimum they charge.

    Example: Length in (Metres) x Width in Metres x 25.00

    Here’s the simple standard formula that I’m using: prec((fieldname2*fieldname3*25.00),2)

    Anyone now how to set to show 300 if the final calculated output is less that 300?

    https://www.ads-software.com/plugins/calculated-fields-form/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hi,

    Yes, you simply should use the MAX operation in your equation to be sure the result would be the bigger number between the mathematical operation and 300, just as follows:

    PREC(MAX(fieldname2*fieldname3*25,300),2)

    Best regards.

    Thread Starter foxtucker

    (@foxtucker)

    Thanks. That works great! Very worthy of a 5 star rating

    Plugin Author codepeople

    (@codepeople)

    Hi foxtucker,

    Thank you very much.

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Minimum Value to show if less than a specified figure’ is closed to new replies.