The statement that follows the IFstatement can be any statement that can be evaluated as true or false. The statement that follows the IFstatement can appear as described below:

• IF A.200>0(simple evaluation)

• IF A.200>0 AND A.200<10,000(complex statement)

• IF A.200>10000 OR ((A.340/B.1200)*2 <1200)(complex statement containing multiple expressions)

The term Periodsin an IFstatement is the number of periods for the report. This term is commonly used for calculating a year-to-date average. For example, when running a report for period 7 YTD, B.150/Periodsmeans to divide the value in row 150 of column B by 7.

The THENand ELSEformulas can be any valid calculation from the simplest value assignments to complex formulas. Note the following formula:

IF A.200>0 THEN A=B.200

The statement specifies that "if the value in the cell in column A of row 200 is greater than zero, then place the value from the cell in column B of row 200 into the cell in column A of the current row."

In this statement, you can also use the @ character in either TRUE/FALSEevaluations or in the formula to represent all columns. For example, the formula described in the preceding IF/THENstatement places a value in one column of the current row. Other examples are described below:

• IF A.200 >0 THEN B.200: When the value in cell A.200 is positive, the value from cell B.200 is positioned into every column of the current row.

• IF A.200 >0 THEN @200: When the value in cell A.200 is positive, the value from each column in row 200 is positioned into the corresponding column in the current row.

• IF @200 >0 THEN @200: If the value in row 200 of the current column is positive, the value from row 200 is positioned into the same column in the current row.