Formulas, apply limits to results

To limit the maximum value a formula may yield you must use the LIMIT function

It looks like this
LIMIT ( MAXVALUE, YOURFORMULAORVALUE)
In our example, the formula takes a distance and multiplies it by 4. The resulting score should not exceed 100.
Our sample data


The last result yields a 120. We will aply the limit function to make it 100
The original formula looks like this. Below, the same formula with a limit on 100.



This will be its result




If we used both the Limit and Positive functions in our previous example, it would look like this
POSITIVE ( LIMIT(100,DISTANCE x 4))