## How to use the IFS function

*Article updated on April 17, 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:

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:

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

### Functions in 'Logical'

The IFS function function is one of many functions in the 'Logical' category.