# IFS

## Content

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

## Syntax

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

## Arguments

This function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *condition1* | [Required] Refers to a value or expression to evaluate. |
| *value1* | [Required] 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 up to 127 different conditions.

## Examples

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