Check multiple conditions in order and return the value for the first one that is true.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
IFS(test1, value1, [test2, value2], …)IFS replaces deeply nested IF statements. It evaluates condition/value pairs from left to right and returns the value for the first TRUE condition. Add a final TRUE test as a catch-all default. Available in Microsoft 365 and Excel 2019+.
=IFS(B2>=90,"A", B2>=80,"B", B2>=60,"C", TRUE,"F")Result: B
Grades a score across bands, with TRUE as the fallback.
No condition was TRUE. Add a final TRUE test as a catch-all default value.