IFS function
Checks several conditions in order and returns the value for the first one that is true.
Syntax
=IFS(test1, value1, [test2, value2], …)| Argument | What it means |
|---|---|
test1 | The first condition to check. |
value1 | The result when test1 is TRUE. |
test2, value2, …optional | More condition and result pairs. |
Example
=IFS(B2>=90,"A",B2>=80,"B",TRUE,"C")Grades a score. The final TRUE acts as “everything else”.
Try itType =IFS( in E2 and click cells to fill in the arguments.
Undo
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Item
Qty
Price
Date
Try here
Apples
12
$0.50
2024-01-15
Bananas
30
$0.25
2024-02-29
Cherries
8
$3.20
2024-04-30
Dates
15
$2.75
2024-07-27
Figs
5
$1.90
2024-12-01