Logical functions make Excel smart by automating decisions based on conditionsโperfect for data analysis and reports.
๐น 1. IF Statement
Checks a condition and returns different values based on TRUE/FALSE.
Syntax:
=IF(condition, value_if_true, value_if_false) โ Example:
=IF(A1>50, "Pass", "Fail") Returns "Pass" if A1 > 50, else "Fail".
๐น 2. AND Function
TRUE only if all conditions are met.
Syntax:
=AND(condition1, condition2,...) โ Example:
=IF(AND(A1>=50, B1>=50), "Eligible", "Not Eligible") Both A1 and B1 need to be 50+ for "Eligible".
๐น 3. OR Function
TRUE if any condition is met.
Syntax:
=OR(condition1, condition2,...) โ Example:
=IF(OR(A1="Yes", B1="Yes"), "Approved", "Denied") "Approved" if either A1 or B1 is "Yes".
๐น 4. NOT Function
Flips TRUE to FALSE and vice versa.
Syntax:
=NOT(condition) โ Example:
=IF(NOT(A1=""), "Filled", "Empty") "Filled" if A1 isn't blank.
๐ก Combine Them:
=IF(AND(NOT(A1=""), B1>0), "Valid", "Invalid")๐ฌ Tap โค๏ธ for more!