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 original formula looks like this. Below, the same formula with a limit on 100.
This will be its result
Making a result always positiveThe POSITIVE function will always yield 0 or a positive value. It looks like this
If we used both the Limit and Positive functions in our previous example, it would look like this