Using Excel's IF & AND function Assume you have a table containing the results of two exams. The initial score, which is stored in column C, must be at least 20. The second score, which appears in column D, must be at least 30. A student passes the final test only if both of the above conditions are met.
The simplest approach to create a suitable formula is to write out the condition first, then incorporate it into your IF function's logical test argument:
AND(B2>=20, C2>=30) is a condition.
The IF/AND formula is as follows:
=IF((AND(C2>=20, D2>=30)), "Pass", "Fail")