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.