IFS Function: In the last post, we talked about the IF Function. Now we will look at the IFS function.
The IFS checks if one or more conditions are met, and gives a value for the first condition that is TRUE. IFS can be used instead of multiple nested IF statements, and it is easier to read when there are many conditions.
What is IFS Function ?
The IFS function in Excel allows you to test multiple conditions and returns a value corresponding to the first TRUE result. Here’s the syntax for the IFS function:
Syntax:
IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3, value_if_true3],…)
Argument Description logical_test1 (required) Condition that evaluates to TRUE or FALSE. value_if_true1 (required) Result to be returned if logical_test1 evaluates to TRUE. Can be empty. logical_test2…logical_test127 (optional) Condition that evaluates to TRUE or FALSE. value_if_true2…value_if_true127 (optional) Result to be returned if logical_testN evaluates to TRUE. Each value_if_trueN corresponds with a condition logical_testN. Can be empty.
Here’s an example of how to use the IFS function:
=IFS(A1<5, "Low", A1<10, "Medium", A1<15, "High", "Very High")
In this example, if the value in cell A1 is less than 5, “Low” is returned; if the value is between 5 and 9, “Medium” is returned; if the value is between 10 and 14, “High” is returned; otherwise, “Very High” is returned as the default value.
Example
In this example we will learn IFS function. IF marks of students matches the condition then Grade will be allotted accordingly.
We have one column Marks obtained that contains marks obtained by students and as per the below table we need to give grade to them:
Marks | Grade |
90 | A |
80 | B |
75 | C |
65 | D |
50 | E |
If marks obtained is 90 or more then Grade A will be given. similarly IF 80 or More then “B”, If 75 or more then “C”, If 65 or More then “D”, if 50 or more then “E”.
Practice IFS Function
You can use this IFS fromula/function given below: =IFS(B6>=B$15,C$15,B6>=B$16,C$16,B6>=B$17,C$17,B6>=B$18,C$18,B6>=B$19,C$19)
Lookup & Reference | How to Use Excel HLOOKUP Function?
HRA Can be Claimed Even If Rent Paid to Spouse – ITAT
Verification of Marks of CS Examinations December-2020
Verification of Marks of CS Examinations June 2021
Join EduTaxTuber Network for the Latest News and updates on Income Tax, GST, Company Law, Stock Market and other related subjects.
Disclaimer: The views expressed are solely those of the author and Edutaxtuber. The content in this piece is solely intended for informational purposes and for personal, non-commercial use. It should not be considered as professional advice or an endorsement by any organization. The author, the organization, and its affiliates disclaim any liability for any loss or harm resulting from the information in this article, as well as for any decisions made based on it.