メインコンテンツまでスキップ

logoCorrectSize.png

Looks like this logo isn't being used anymore since we started using the new CSS to make our documentation look like our product UI.

Knowledge @ Adaptive Insights LLC, a Workday Company

Difference between IF and IFF

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release. 

Question

What is the difference between using IF and IFF in a formula?

Answer

IFF only evaluates the path of the formula that meets the stated condition whereas IF evaluates both parts of the formula. When creating formulas with IFF and IF, the syntax is the same. We recommend initially creating a formula with an IF statement to make sure that both parts of the formula are valid and test both paths. Once you have established and tested the formula, if your formula is complex and taking a long time to calculate, then try IFF to see if this improves the performance. Sometimes using the IFF statement will help you avoid circular references in formulas where you are referring to time.

  • この記事は役に立ちましたか?