The equals to operator, “=,” is the most commonly used logical test. For instance, in the second example, the evaluation of the first logical test Logical Test A logical test in Excel results in an analytical output, either true or false.Clicking the “Evaluate” button will show all the steps in the evaluation process. Evaluate the formula logic– To see the step-by-step evaluation of multiple IF conditions, we can use the ‘Evaluate Formula’ feature in excel on the “Formula” tab in the “Formula Auditing” group.Note: Changing the order of the IF function in Excel would change the result. Since 85 is greater than or equal to 70, a result of this condition is also “True,” so the formula would return “Average” instead of “Excellent” without testing the following conditions. In this case, the formula tests the first condition. Now, if we reverse the order of IF functions in Excel as follows:
Now, let us say we want to test one more condition in the above example: Next, drag the formula to get the results of the rest of the cells. This formula returns the result as given below: Bad: =70,C2>=70), and then nest them into logical tests of IF functions as follows: