# Formulas, applying limits on results

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

It looks like this

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

**LIMIT**functionIt 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 original formula looks like this. Below, the same formula with a limit on 100.

This will be its result

#### Making a result always positive

The POSITIVE function will always yield 0 or a positive value. It looks like this**POSITIVE ( YOURFORMULAORVALUE)**

If we used both the Limit and Positive functions in our previous example, it would look like this

**POSITIVE ( LIMIT(100,DISTANCE x 4))**