Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Convert text string to valid reference in Excel using Indirect function
  • How to reference named range different sheet in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel VLOOKUP Function
  • Offset in Excel

Data Analysis Examples

  • How To Compare Two Lists in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How to create dynamic reference table name in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Move chart to a separate worksheet in Excel

Data Validation Examples

  • Excel Data validation unique values only
  • How To Create Drop-down List in Excel
  • Excel Data validation allow uppercase only
  • Excel Data validation don’t exceed total
  • Excel Data validation exists in list

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:   If cell equals in Excel

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:   How to use Excel OR Function

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:   Calculate number of hours between two times in Excel

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:

Prevent invalid data entering in specific cells

Next Post:

Count and Sum Functions 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
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • Replace one character with another in Excel
  • How to get page from URL in Excel
  • How to get last line in cell in Excel
  • How to create email address from name in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • Extract time from a date and time in Excel
  • How to calculate future date say 6 months ahead in Excel
  • Basic Overtime Calculation Formula in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate present value of annuity in excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles