IFS Function in Google Sheets

Evaluate multiple conditions in Google Sheets using the IFS function.

IFS Function

The IFS function in Google Sheets returns a value from the first TRUE condition in a list of conditions.

Syntax

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

Examples

  1. Basic IFS Usage

Return a grade based on score:

=IFS(A1 >= 90, "A", A1 >= 80, "B", A1 >= 70, "C", A1 < 70, "F")

This will return ‘A’ if A1 is 90 or more, ‘B’ if 80 or more, ‘C’ if 70 or more, and ‘F’ otherwise.

Notes

  • The IFS function is an alternative to nested IF statements.
  • Conditions are evaluated in the order they appear, and the first TRUE condition’s value is returned.
  • IF: Returns a value based on a condition.
  • SWITCH: Evaluates an expression against a list of values and returns the corresponding result.