IFS()

Description

Evaluates multiple conditions and returns a value that corresponds to the first true condition..

How To Use in Sheets

IFS(condition1, value1, [condition2, value2], …)

External Links

Using OR, AND, NOT, IF, and SWITCH: Introduction to Programming with Google Sheets 06-D

In this video we demonstrate some of the functions in Google Sheets we can use to make decisions.