Scribd
Upload
8 views1 page

Excel Logical Functions Colorful Quick Note

The document outlines the use of Excel logical functions: OR, AND, IF with OR, and IF with AND. It describes their purposes, return types, and best use cases, emphasizing the difference between basic checks and custom results. Examples are provided for each function to illustrate their application.

Uploaded by

SHIVAM CHAUHAN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views1 page

Excel Logical Functions Colorful Quick Note

The document outlines the use of Excel logical functions: OR, AND, IF with OR, and IF with AND. It describes their purposes, return types, and best use cases, emphasizing the difference between basic checks and custom results. Examples are provided for each function to illustrate their application.

Uploaded by

SHIVAM CHAUHAN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Quick Note for Excel Logical Functions

1. OR Function
- Checks multiple conditions together.
- Returns:
- TRUE if any one condition is TRUE.
- FALSE if all conditions are FALSE.
- Cannot show custom words like 'Pass' or 'Fail' (only TRUE/FALSE).
Example: =OR(A2 >= 50, B2 >= 50)

2. AND Function
- Checks multiple conditions together.
- Returns:
- TRUE if all conditions are TRUE.
- FALSE if any condition is FALSE.
- Cannot show custom words (only TRUE/FALSE).
Example: =AND(A2 >= 50, B2 >= 50)

3. IF with OR Function
- Checks conditions using OR and then gives custom words.
- Use when you need to show words like 'Pass' or 'Fail' if any condition is TRUE.
Example: =IF(OR(A2 >= 50, B2 >= 50), 'Pass', 'Fail')

4. IF with AND Function


- Checks conditions using AND and then gives custom words.
- Use when you need to show words like 'Pass' or 'Fail' only if all conditions are TRUE.
Example: =IF(AND(A2 >= 50, B2 >= 50), 'Pass', 'Fail')

Super Quick Summary


Function | Purpose | Result Type | Best For

-----------|----------------------------------|------------------|--------------------------------

OR | Any condition TRUE -> TRUE | TRUE/FALSE | Basic checking (any condition met)

AND | All conditions TRUE -> TRUE | TRUE/FALSE | Strict checking (all must pass)

IF + OR | Any condition TRUE -> Show word | Custom Words | Flexible checks with custom results

IF + AND | All conditions TRUE -> Show word | Custom Words | Strict checks with custom results

You might also like