Press Enter.īoom!! You have got your results by using nested if for more than one logical test. Now close the bracket and put a comma and write “Fail” for 4 th condition, again close the bracket put a comma and write “Fail” for 3 rd,2 nd and 1 st condition.Again put a comma to enter what if last condition is not fulfilled.Now press comma to write what if all conditions are fulfilled, write “Pass” after comma.So write if again and again like this till all of your condition is fulfilled. Again, we will check another condition on success of 2 nd one.So write the second condition in value if true by using additional if. If this (b5>=40) is true, we want excel to check another logical test.Let’s start by writing first logical test in if function.Passing Criteria = Individual 40 Marks and overall 50%Īlternatively above arguments can be put up through multiple if instead of using and function. Now we have to apply the nested if as we have to use more than one if statements to get out desired results. Let’s take again the same example of students’ results stats. But what if we want to evaluate by two logical test.” Say like student must have obtained 40 marks in individual subject and overall 50%? Here, If and And as well as Nested If Function come into picture.
“Wow, learned how to use logical test in if. If all the logical test is cleared by that set of cells, if function gives you “Value if true”, otherwise “Value if False”. Here, if function test the logical argument given by you on the cells specified by you. You will see that 3 rd student has not cleared exam yet. Now, drag down the formula by selecting all 4 cells from G4:G7 and press Ctrl + D. “Fail” If student obtained less than 50%, cell should show “Fail” “Pass” If student is pass, we want “Pass” as an outcome Here we have use logical test like if total % is equal to or greater than Wildcards like ? and * can be used in if formula.į4/400>=0.5 total marks obtained divided by total marks will give you %.Numeric criteria can be written without double inverted comma.Non- numeric criteria has to be written with double inverted comma (e.g.: Here, we have to put the value we want on failure of logical test. : Here, we have to write the value we want on fulfillment of conditions laid in logical test. Logical test: Here, we required to insert logical argument, based on which excel will check the logic and returns true value if the logical arguments are satisfied and value of false if not. =if(Logical test,, ) Arguments of the If function 4.2 Solution 2: Using And function with If function.2.1 Points to be considered while using if:.