Author: Oscar Cronquist Article last updated on June 16, 2018

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

The IFS function is a better alternative to nested IF functions.

Formula in cell C3:

=IFS(B3>95, "A+", B3>89, "A", B3>84, "B+", B3>79, "B", B3>74, "C+", B3>69, "C", B3>64, "D+", B3>59, "D", B3>=0, "F")

The formula in above picture calculates the grade based on the following score levels.

A+ score > 95
A score > 89.
B+ score > 84
B score > 79
C+ score > 74
C score > 69
D+ score > 64
D score > 59
F score > 60

Excel Function Syntax

IFS(logical_expression1, Value_if_True1, [logical_expression2, Value_if_True2],…)

The IFS function allows you to have up to 127 pairs of logical expressions and value if true.

Arguments

logical_expression1 Required. The logical expression you want to use.
Value_if_True1 Required. The value to be displayed if logical expression is met.
[logical_expression2, Value_if_True2] Optional. Additional arguments.

Comments

The IFS function is an Excel 2016 function, however, you can replicate the behavior with the following formula if you have an earlier version of Excel.

Formula in cell C3:

=INDEX($F$3:$F$11, MATCH(B3, $E$3:$E$11))

The formula above uses the table E3:F11 to match the correct grade with score.