How to use the New Excel IFS Function instead of nested IF
Step 1: Open Excel Sheet and Select Cell
Open your Excel worksheet and select the cell where you need to show the result of the IFS function.
Step 2: Give IFS Command to Start
Type =IFS within the chosen cell to start the function.
Step 3: Apply the Conditions
Specify the conditions and compare the values utilizing the following sentence structure: condition1, value1, condition2, value2,…, condition_n, value_n.
Step 4: Give Condition in the form of expression or comparison
Separate each condition-value match with a comma. The condition can be any coherent expression or comparison, whereas the esteem can be any information sort or formula.
Step 5: Press OK
Step 6: Repeat the above method for all the conditions you need to evaluate.
Step 7: Close the function by writing “)” and press Enter
The IFS work will assess the conditions within the arrangement they are given and return the value compared to the primary condition that is assessed as genuine. If none of the conditions are met, the work will return a mistaken value.
Example:
Whether you’re a newbie attempting to learn the basics or an experienced Excel client looking to make strides in your formula-building abilities,
We’ll break down the IFS function’s utilisation and outline its adaptability in taking care of different circumstances and returning proportionate values by mixing composed clarifications with visual representations.
The examples of usage for IFS function are given below:
The representation of same input in the formula bar is given below:
How to use the IFS function in Excel
The IFS function in Excel acts as a keen partner, making choices for your information. It’s perfect when you have different rules and wish to grant prizes based on those rules. Rather than getting misplaced in complicated enlightening, IFS assists your information in getting to where it ought to go. It’s interesting that once you have several conditions and have to decide which one is redressed.
Contact Us