MS Excel Logical Functions

Function name Description Example
AND Return true if all the inputs are true otherwise false. =IF(AND(A1>33, B1>33), "Pass", "Fail")
OR Return true if one or all the inputs are true otherwise false. =IF(OR(A1>33, B1>33),"Pass", "Fail")
NOT Return negation of any input =NOT(TRUE)
IF Apply condition on the dataset =IF(AND(A1>33, B1>33), "Pass", "Fail")
© 2016 - 2022, All Rights are Reserved.