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))
    21 AUG

    iDoceo 7 for iPad and Mac now available!

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

    Read more

    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

    Read more

    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.