### iDoceo 7 for macOS and iPadOS now available!

You will find all the details explained here

# 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

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

#### Recently updated articles

21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.