To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate conditions that will show two outcomes. This excel if statement is used to analyze a condition that will show two outcomes. Basically, excel logical test is used to evaluate the condition whether it is true or false.
Table of Contents
If statement is mainly used to test any condition that will give you more than two outcomes. If you are using a single If then it will give you two outcomes. For more than two outcomes you need to use If statement inside another If statement.
For multiple situations, you have to apply multiple If statement to get more than two outcomes. This means that you are creating if function within another if function.
If(logical_test, [value_if_True], [Value_if_false])
You have conditions:
Less than $300: Receive 7% commission
Sales btw $300 to $600: Receive 12.5% commission
Sales more than $600: Receive 16% commission
Now to find commission, we have to apply If statement. You must use nested if to calculate commission of all salesperson.
Hence, in this situation, if statement will check whether the value in B2 is greater or less than $300. If it is so, then the commission is 7%. If B2 is in between $300 to $700 then the commission will be calculated at 12.5% and if the figure is more than $700, then the commission will be calculated via 16% rate.
In these four outcomes, you require three different conditions. Excel If statement multiple conditions range tests a single condition and returns an outcome.
=IF(Condition A, Output Y, IF (Condition B, Output Z, IF (Condition C, Output R, Output S))))
In this formula, we have three conditions that will show 4 outcomes.
We start with, testing If statement A is true or not. If it is true then it will return output B
But if the condition is False then testing of B condition will start
If condition B is true, then the output will be Z and if it is false, the testing of condition C will begin.
If condition C is true then it returns R else S.
Let us take the situation and conditions
Syntax to find the grade is
=If(F2>=70,”Distinction”,IF(F2>=60,”CREDIT”,IF(G2>50,”PASS”,”FAIL”)))
This is how you will be going to perform excel logical test on multiple conditions to get different outcomes.
The digital revolution has propelled us into a cloud-based world. Businesses are increasingly migrating their… Read More
Serverless computing has become a game-changer in the cloud development landscape. By abstracting away server… Read More
The digital age has brought an explosion of data. From personal photos and documents to… Read More
In the ever-evolving landscape of cloud computing, selecting the right tools for your applications is… Read More
Cloud Computing is present and future of remote technologies. In today's dynamic business landscape, digital… Read More
NGINX Server Nginx, a popular open-source web server, excels at handling high traffic websites efficiently.… Read More