Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to combine 2 or more chart types in a single chart in Excel
  • How To Compare Two Lists in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Understanding Anova in Excel

References

  • Lookup entire row in Excel
  • Extract data with helper column in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Merge tables with VLOOKUP in Excel
  • How to use Excel MATCH Function

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation must contain specific text
  • Excel Data validation specific characters only
  • Data validation must not exist in list
  • Excel Data validation allow weekday only

IF, AND, OR and NOT Functions Examples in Excel

by

Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function.

If

The IF function checks whether a condition is met, and returns one value if true and another value if false.

1. For example, take a look at the IF function in cell C2 below.

Above Case Study Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail. Visit our page about the IF function for many more examples.

And

The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.

1. For example, take a look at the AND function in cell D2 below.

Above Case Study Explanation: the AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90, else it returns FALSE.

Or

The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.

1. For example, take a look at the OR function in cell D2 below.

Above Case Study Explanation:the OR function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE. Visit our page about the OR function for many more examples.

Not

The NOT function changes TRUE to FALSE, and FALSE to TRUE.

1. For example, take a look at the NOT function in cell D2 below.

Above Case Study Explanation: in this example, the NOT function reverses the result of the OR function (see previous example).

Post navigation

Previous Post:

TRUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Pie Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Complete List of Excel Logical Functions, References and Examples
  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel FALSE Function
  • SWITCH function example in Excel
  • Return blank if in Excel

Date Time

  • Calculate series of dates by workdays in Excel
  • Get month name from date in Excel
  • Add months to date in Excel
  • Roll back weekday to Friday base on a particular date in Excel
  • Get first day of previous month in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Running count group by n size in Excel
  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to get original price from percentage discount in Excel
  • How to get original number from percent change in Excel
  • How to get amount with percentage in Excel
  • Split Cell Content Using Text to Columns in Excel
  • With vs Without Array Formula in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning