IFS function

This article explains how to use the IFS function

Often it is useful to check multiple conditions and return some value based on the first condition that is true. Even though, it is possible to achieve this pattern by chaining the IF function, it is often simpler and cleaner to use IFS.

IFS allows you to provide as many condition and value if condition is true pairs as you want. It will then return the value associated with the first condition that is found to be true.

Syntax

FS
IFS(condition_1, value_1, condition_2, value_2, ..., condition_n, value_n)

Usage

FS
IFS( QA < 1, VA, QA < 5, VB, QA < 10, VC )
ConvertCalculator Icon

The and