Learn How to Use Microsoft Excel IFS Function

Microsoft Excel IFS Function

The IFS function is used to test the multiple conditions and returns first true. That implies, the IFS Microsoft Excel function runs numerous tests and returns the value according to the first TRUE result. You can use the IFS function without multiple nests like IF and can evaluate the numerous conditions. IFS allows formulas that are shorter, easier, and easy to pursue.

IFS Functions Return Value

The value is related to the first TRUE result.

IFS Function Syntax

=IFS(test1,value1, [test2,value2,...)

Where:

• test1: First logical result.
• value1: Result when test1 is TRUE.
• test2: Second logical result (Optional)
• value2: Result when test2 is TRUE (Optional)

How to Use Microsoft Excel IFS Function?

IFS is a new function and available in Office 365 and Excel 2019. As we know, you can use the IFS function to test the multiple conditions and return the value corresponding to the first TRUE result. You can use the IFS function without nesting to test the multiple conditions, unlike the IF function. Formulas based on the IFS function are easy to read and shorter.

The conditions are entered in test/value pairs, and each test represents a logical test that returns the value TRUE or FALSE corresponding to it. The IFS formula with four values will be given below:

=IFS(

test1,value1

test2,value2

test3,value3

test4,value4

)

The first test that returns the TRUE value will be the winner.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel