iDoceo 6 is now available!

We are updating the web with all the new features of iDoceo 6.
This is a manual update, please tap on this link if you wish to update on the App Store

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))
    13 APR

    iDoceo 5.1 is now available!

    An amazing update with tons of new features. Audio questions in iDoceo Connect, countdown timer, feedback and more

    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