Logical
IFS function
First value whose condition is TRUE. IFS works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=IFS(condition1, value1, [condition2, value2, ...]) | Argument | Use |
|---|---|
condition1 | required, repeatable |
value1 | required, repeatable |
condition2 | optional, repeatable |
value2 | required, repeatable |
| required |
Example
Pick the first band whose condition holds.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Status | Amount | Date |
| 2 | #1001 | Acme Ltd | North | Paid | 1200 | 2026-01-14 |
| 3 | #1002 | Blue Fox | South | Open | 450 | 2026-01-20 |
| 4 | #1003 | Acme Ltd | North | Paid | 980 | 2026-02-03 |
| 5 | #1004 | Cedar & Co | East | Overdue | 2300 | 2026-02-11 |
| 6 | #1005 | Blue Fox | South | Paid | 610 | 2026-03-02 |
| 7 | #1006 | Delta BV | West | Open | 1750 | 2026-03-09 |
| 8 | A |
Result computed by the Sheets formula engine.
On live data
In Sheets, IFS sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More logical functions
ANDTRUE if all are TRUEIFConditionalIFERRORFallback if value errorsLETName values for a calculationORTRUE if any is TRUESWITCHResult for the matching valueBYCOLApply a LAMBDA to each columnBYROWApply a LAMBDA to each rowFALSEThe logical value FALSEIFNAFallback if value is #N/AISOMITTEDTRUE if a LAMBDA argument is missingLAMBDAA reusable function
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.