The IF function returns one value if a specified condition evaluates to true or another value if the condition evaluates to false. Using the IF function requires completing the following tasks, as shown in Figure 4-8:
In Value True, select a value or type the value to display if the condition evaluates to true, such as Very good.
In Value False, select a value or type the value to display if the condition evaluates to false, such as Poor.Figure 4-9 displays the resulting cross tab, which displays the Revenue Rating column containing values of Very good and Poor.
|
|
Copyright Actuate Corporation 2012 |