To build a conditional formula:
Connect the “test” and “test against” values to the top and bottom of a comparison operator.
Connect the comparison operator output to the center of an “IF” operator.
Connect the “value if true” to the top and “value if false” variables to the bottom of the "IF" operator.
Connect the left side of the "IF" operator to the “result” node which will hold the result of the entire calculation.
For example, this table shows the values and result of the above formula when “Test” is greater than “Test Against” and, therefore, evaluates as true. Because of this, “Result” is equal to the value of “Value if True":
When “Test” is less than “Test Against” and, therefore, evaluates as false, “Result” is equal to the value of “Value if False.”
What's next?
Read about scenarios to compare different sets of data modeled on the same underlying formulas.
Learn how to share your models with your team and other stakeholders.