### 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.

Hi SteveMND,

Try using the Max function:

=Max[yourCalcField; Threshold]

(e.g. Max[(X-Y) ; 20] )