# IFS

## 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.