Making decisions with conditional functions and expressions

Conditional functions and expressions help you to determine any one of multiple alternative result values depending on certain input conditions. Let us discuss a scenario where you can use conditional expressions.

In an examination, the grade is A for aggregate marks above 85%, B for marks between 71% and 85%, C for marks between 61% and 70%, D for marks between 45% and 60%, and E for the rest. In these scenarios, AppSheet conditional functions will allow you to compute any one resulting grade in a results column titled, say, [GRADES], depending on the range of marks as input conditions in the other column, titled, say, [PERCENT_MARKS]. The range of marks is the condition on which to decide the grades. Also note that there are several possible results of grades based on the range of marks, but for any one particular value of marks, only one result is correct. You can enter the conditional expressions in the column where...