How to use IF THEN logic in formulas

It is possible to use IF THEN logic in assessment and custom forms formulas. There is no direct IF THEN syntax but the same result can be achieved by using the comparison operators below.

> (greater than)
< (less than)
<= (less than or equal)
>= (greater than or equal)
== (equal)

Example

The example below illustrates an IF THEN formula used to return total distance covered during a shuttle run test. The recorded data is the last completed stage. The calculated result will be the total distance covered at the end of the last completed stage.

Formula: (laststa==1)(40)+(laststa==2)(80)+(laststa==3)(120)

laststa= last completed stage

== comparison operator

(40), (80), (120)=returned value when the condition laststa ==  is met

Each block condition  and return value (eg: (laststa==1)(40) must be separated by a + sign. You can add as many block as you need and use a combination of comparison operators

To use this formula, you'll need to create a 'Shuttle test (distance)' that will be the result of the formula.

Then add the new test to the battery

And finally enter data and click Save. The distance covered will be automatically calculated.

You can use the same logic/syntax to add any IF THEN formula. For example, to return an age and gender related predicted VO2max.

(gender==1)*((age<30)*53+and(age>=30,age<40)*50+and(age>=40,age<50)*45+and(age>=50,age<60)*43+(age>=60)41)(gender==0)((age<30)*33+and(age>=30,age<40)*30+and(age>=40,age<50)*27+and(age>=50,age<60)*24(age>=60)*23)