PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
IFS function comes under the LOGICAL FUNCTIONS category in Excel.
IFS function is very important and is going to be used a lot which makes it one of the very important functions in excel.
THE IFS FUNCTION CHECKS THE DIFFERENT GIVEN CONDITIONS AND RETURNS THE CORRESPONDING VALUE OF THE FIRST TRUE CONDITION.
This function is an extension to the very useful IF FUNCTION.
In this article, we’ll learn about the purpose, formula syntax and examples of the IFS FUNCTION IN EXCEL.
IFS FUNCTION is simply an extension to the very useful IF FUNCTION.
IFS Function lets us insert a number of conditions and the associated values if that particular condition is true.
If you have been using the EXCEL for a while, you must have used the NESTED IF FUNCTION. IFS function is a dedicated function for the NESTED IF which is more readable and easy to implement.
For the first time users, let us try to understand the IFS FUNCTION.
Suppose we have different codes for the fruits. Such as
1 – Apple
2 – Banana
3 – Pine Apple
4 – WaterMelon
and so on.
We need to put the condition to check the name of the fruit from the given code using the IFS FUNCTION.
We would put the function as
IFS( ” If code = 1″, Return Apple, ” If code =2 ” Return Banana , If code = 3…. and so on.
We’ll learn the proper formula in the examples below.
Simply stating, we’ll use IFS when we need to put a number of conditions in the same statement or simply speaking it is a MULTIPLE IF.
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
The Syntax for the IFS function is
=IF(TEST CONDITION 1, VALUE IF CONDITION 1 IS TRUE, TEST CONDITION 2, VALUE IF CONDITION 2… )
TEST CONDITION is the test condition which you want to test. The condition must return a TRUE OR FALSE.
VALUE IF CONDITION IS TRUE is the value which will be returned by the function if the corresponding condition is true.
We can enter up to 127 conditions.
If more than two conditions are true, the leftmost condition will be executed and value will be returned.
For the better understanding of the use of IFS FUNCTION, let us take an example.
We have SPECIAL CODES for a few fruits which are given below.
We want Excel to find out the fruit on the basis of selected code.
We’ll create a simple drop down list and the output cell will show the fruit chosen.
STEPS TO CREATE A DROP DOWN LIST:
*the drop down list creation steps are brief as there is a complete article for the same. [ CLICK HERE TO VISIT]
Now , the list is already created. Now we want to put the formula using the function IFS to find out the fruit code immediately after selecting the fruit code.
STEPS TO USE IFS FUNCTION TO CHOOSE THE FRUIT ON THE BASIS OF FRUIT CODE.
STEPS TO USE IFS FUNCTION TO CHOOSE THE FRUIT ON THE BASIS OF FRUIT CODE.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE