IF

The IF() command performs conditional tests within a formula. Using the IF statement, you can define a Boolean test, as well as formulas to be calculated if the test returns either a TRUE or FALSE value.

Syntax

IF( condition ) statement ; [ ...statement ; ] [ ELSEIF...statement | ELSE...statement]
ENDIF;

condition Formula or function that returns a Boolean value of TRUE (a nonzero value) or FALSE (a zero value).

statement Operations to be performed depending on the results of the test.

Notes

The IF statement block can also use the ELSE and ELSEIF statements as part of its decision syntax.
For information about using ENDIF statements and semicolons with IF, ELSE, and ELSEIF statements, see ENDIF.
In calc scripts, IF statements must be placed within parentheses and associated with a specific database member. They must also be closed with ENDIF statements. For more information, see the Database Administrator's Guide.
You can specify attributes in IF statements using the @ATTRIBUTE and @WITHATTR functions; for example IF (@ISMBR(@ATTRIBUTE(Can))) .... You must use these functions; IF(@ISMBR(Can)) is not supported.

Example

IF(
	@ISMBR(@DESCENDANTS(Europe))
OR	@ISMBR(@DESCENDANTS(Asia))
  )
   Taxes = "Gross Margin" * "Foreign Tax Rate";
ELSE
   Taxes = "Gross Margin" * "Domestic Tax Rate";
ENDIF;

This test checks to see if the current cell includes a member that is a descendant of either the Europe or Asia members. If it does, the formula calculates the taxes for the member based on the foreign tax rate. If the current cell does not include a member from one of those groups, then the domestic tax rate is used for the tax calculation.

The next three commands are included here for convenience. These commands can be used only with the IF command.

See Also

ELSE
ELSEIF
ENDIF

condition	Formula or function that returns a Boolean value of TRUE (a nonzero value) or FALSE (a zero value).
statement	Operations to be performed depending on the results of the test.