IF (logicaltest,valueiffalse) A logical test is any value or expression that can be evaluated to TRUE or FALSE. Use IF to conduct tests on values and formulas.
But, if both cells a has a value lower than 40 then AND will return false and IF will return value “Fail”. IF Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. That means if a student is passed in both of the subjects then he/she will pass. In the above formula, if there is a value 40 or greater than in any of the cells (B2 & C2) AND function will return true, and IF will return value “Pass”. If a student is passed in both of the subjects with 40 marks or above, the status should be “Pass”Īnd, if a student has less than 40 marks in both of the subjects or even in one subject, the status should be “Fail”. And, I want to add some remarks in the sheet. And, if any of the conditions is false then AND function will return false and IF function will return the value which you have specified for false. If all the conditions are true then AND function will return true and IF function will return the value which you have specified for true. Now, AND function will test your all conditions here. By using AND function you can specify more than one condition. To combine IF and AND functions you have to just replace logical_test argument in IF function with AND function.