IF statement enable you to define criteria that must be exist for another event to occur. Use an IF statement to identify the values to use, or the calculations to perform, in a particular situation.
For example, assume that a scorecard uses ten measures of equal weight. Eight measures score 90% and two score 5%. To prevent the scorecard score from being too low, use IF to calculate and use a different score. For example, you could state that 50% replaces the score for each measure if the measure’s actual score is less than 25%.
You can also use IF to specify the data to use instead if results for a measure used in other formulas are unavailable. In this situation, you could use IF to insert the most recent result collected by the measure.