iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here

Formulas: IF condition

The IF condition does one operation or another depending on a defined math expression.
Math expressions and conditions can be as complex as necessary, they can be nested or include boolean operators.

IF ( expression, operation_if_true)

In this format if the expression is true, the operation is done.

IF ( expression, operation_if_true, operation_if_false)

In this second format, if the expression is true, the first operation is done.
If false, then the second one proceeds

Example 1

This first formula is read like this, IF Test1 is greater than 60, show the green smiley icon
The formula looks like this

And this is the result

Example 2

Similar to our previous example but in this one we will use the second format of the IF condition. If the first expression matches, it performs the first operation, if not, the second one.
It is read like this, IF test1 is greater than 60 show a green smiley icon, if not show red smiley icon

and here the result

The previous formula can also be expressed like this. Note the less than or equal sign in the second condition so that all possible outcomes are taken into account

Example 3

We will see in this example the unlimited options of the first expression we put in a condition
In this formula, we will show a yellow smiley if TEST1 value is greater than 60 but lower than 80
The formula will look like this

    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.