IF function checks/tests a condition or logical test. If the condition is met or TRUE, the outcome will be TRUE value and if the condition is not met or FALSE, the outcome will be the FALSE value.
=IF(C3>=$C$12,"YES","NO")
AND function
AND function checks/tests 2 or more (max 255) condition or logical test. If ALL condition is met or TRUE, the outcome will be TRUE value and if ANY ONE of the condition is not met, the outcome will be the FALSE value.
=IF(AND(C3>=$C$12,D3>=$C$13),"YES","NO")
OR function
OR function checks/tests 2 or more (max 255) condition or logical test. If ANY ONE condition is met or TRUE, the outcome will be TRUE value and if ALL of the condition is not met, the outcome will be the FALSE value.
=IF(OR(C3>=$C$9,D3>=$C$10),"YES","NO")
NOT function checks/tests a condition or logical test. If the condition is met or TRUE, the outcome will be FALSE value and if the condition is not met or FALSE, the outcome will be the TRUE value.
=IF(NOT(C3<6.5),"YES","NO")
Cheers
Dr. MANA
4 Dec 2017
