Home › Functions › Compare IF vs IFS vs SWITCH

Compare IF vs IFS vs SWITCH

3 vs

Compare IF vs IFS vs SWITCH side-by-side — differences, popularity and recommendation

Presets: VLOOKUP vs XLOOKUP SUM vs SUMIFS INDEX vs MATCH vs XLOOKUP IF vs IFS vs SWITCH COUNT vs COUNTA vs COUNTIF AVERAGE vs AVERAGEIF vs AVERAGEIFS MAX vs LARGE vs MIN TEXT vs TEXTJOIN vs CONCAT FILTER vs SORT vs UNIQUE ROUND vs ROUNDUP vs ROUNDDOWN
All functions Pick at least 2 functions
Feature
Logical
=IF()
★ Winner
Syntax
Logical
=IFS()
Syntax
Logical
=SWITCH()
Syntax
Category
Logical logical
Logical logical
Logical logical
Popularity
95 / 100
70 / 100
55 / 100
Views
◉ 19 views
◉ 15 views
◉ 13 views
Output
Mixed
Mixed
Mixed
Version
All versions
Excel 2019
Excel 2019
Volatile
No
No
No
Dynamic Array
No
No
No
Description
How to use the IF function in Excel to make logical comparisons between data values.
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. If there are no matching values, and no default argument is supplied, the SWITCH function returns the #N/A! error.
Syntax
=IF(logical_test, value_if_true, [value_if_false])
=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)
=SWITCH(expression, value1, result1, [default or value2, result2],…[default or value3, result3])
Arguments
3 Arguments
logical_test value_if_true value_if_false (Optional)
4 Arguments
logical_test1 value_if_true1 logical_test2…logical_test127 (Optional) value_if_true2…value_if_true127 (Optional)
4 Arguments
expression value1…value126 result1…result126 default (Optional)
Examples
5
2
1
Tips
2
2
0

★ Recommendation — Winner: =IF()

=IF() is recommended based on higher popularity, newer version and Dynamic Array support.

Winner: =IF()