Creating Pixel-Perfect Reports > Getting Started with the Reports Tool in the Desktop Application > Building Report > Adding a New Sheet and Working with It > Working with Report Sheet Data > Using Formulas > Function Wizard > Logical Functions > Ifs
The function wizard for the Ifs function:
Ifs(LogicalValue1, ConditionValue1, …)
LogicalValue1, LogicalValue2, …, LogicalValueN. Logical condition.
ConditionValue1, ConditionValue2, …, ConditionValueN. The value, if the condition is set to TRUE.
It checks for correspondence with one or several conditions and returns value for the first condition, which is set to TRUE.
One can set up to 127 conditions.
Parameter values can include numbers, empty cells, logical values, cell references, formulas.
Numbers are interpreted as True, empty cells are interpreted as False.
| Formula | Result | Description |
| =Ifs(K7, 1, K8, 2, G10, 4) | 4 | The value for the third condition, which is the first to set to True. |
See also:
Function Wizard │ Logical Functions
