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

Data Analysis

  • How to calculate average last N values in a table in Excel
  • How to create running total in an Excel Table
  • How to sum a total in multiple Excel tables
  • Subtotal function in Excel
  • How To Filter Data in Excel

References

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Left Lookup in Excel
  • How to use Excel FORMULATEXT function
  • How to use Excel MMULT Function
  • Count rows that contain specific values in Excel

Data Validations

  • Excel Data validation must contain specific text
  • Excel Data validation with conditional list
  • Excel Data validation whole percentage only
  • Excel Data validation allow uppercase only
  • Excel Data validation don’t exceed total

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.

Worked Example:   OR function: Description, Usage, Syntax, Examples and Explanation

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.

Worked Example:   Running count group by n size in Excel

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.

Worked Example:   How to count line breaks in cell in Excel worksheet

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:

Find, Select, Replace and Go To Special in Excel

Next Post:

What-If Analysis: Scenarios and Goal Seek in Excel

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

  • IF with wildcards in Excel
  • Not Equal To ‘<>‘ operator in Excel
  • Extract multiple matches into separate rows in Excel
  • How to use IFS function in Excel
  • Invoice status with nested if in Excel

Date Time

  • Two ways to sum time over 30 minutes in Excel
  • How to Calculate Age in Excel
  • Steps to create Dynamic calendar grid in Excel
  • Get project end date in Excel
  • Display the current date and time in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • Calculate conditional mode with criteria in Excel
  • Group arbitrary text values in Excel
  • Map inputs to arbitrary values in Excel
  • Map text to numbers in Excel

General

  • Count cells that contain errors in Excel
  • Share Excel data with Word documents
  • Freeze and Unfreeze Panes in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
  • Subtotal invoices by age in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning