IFS

Checks multiple conditions, returns first match.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Any value

Examples

=IFS(A1>90, "A", A1>80, "B", TRUE, "C")

	A
1	10

Result C

Syntax

IFS(logical_test1, value_if_true1, [logical_test2…], [value_if_true2…])

logical_test1: boolean required
value_if_true1: any required
logical_test2…: boolean optional
value_if_true2…: any optional

ANDReturns TRUE if all arguments are true. EQTrue when two values are equal. FALSEReturns the logical value FALSE. GTTrue when the first number is greater. GTETrue when the first number is greater or equal. IFReturns one value if condition is true, another if false.