# IFS

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function performs a comparison and returns the specified associated value if comparision is TRUE.

## Syntax

IFS(*condition,value1, [condition2,value2],...*)

## Arguments

This function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *condition1* | Refers to a value or expression to evaluate. |
| *value1* | Refers to a value to return if the test evaluates to true. |
| *[condition2,value2],...* | [Optional] Refers to more conditions to be compared (nested IF statements). |

## Remarks

This function allows users to test upto 127 different conditions.

## Data Types

Accepts numeric (boolean) data for both arguments. Returns any data type.

## Examples

`IFS(A2=89,"A",A2=79,"B")` gives the result B.

## Version Available

This function is available in Spread for Windows Forms 11.0 or later.