6 Replies Latest reply on Feb 23, 2009 10:48 AM by comment_1

    Setting a calculation result to a minimum amount?

    SteveMND

      Title

      Setting a calculation result to a minimum amount?

      Post

      Greetings all.  I'm using Filemaker for personal (as opposed to business) reasons, and so I'm not exactly what you'd call a math wiz.  I've come across a situation in designing a calculation field, but I'm not sure of the formula I need to do so.

       

      Basically, what I want is to have the calculation field do some math, and return what the final result is.  No problem.  However, I also want to ensure that there is a minimum value for that result.

       

      For example, the formula is X-Y, and the threshold is 20.  So 100-20 would return 80, 150-100 would return 50, but 50-45 would return 20, not 5.

       

      I suspect I could do it fair enough with the if/then bit, but I suspect there may be a simpler operation in there I'm missing.