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

Data Analysis

  • Number and Text Filters Examples in Excel
  • Data Series in Excel
  • Everything about Charts in Excel
  • Error Bars in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel

References

  • How to reference named range different sheet in Excel
  • Basic INDEX MATCH approximate in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Create hyperlink with VLOOKUP in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Validations

  • Excel Data validation specific characters only
  • How To Create Drop-down List in Excel
  • Excel Data validation no punctuation
  • Excel Data validation don’t exceed total
  • Excel Data validation exists in list

Complete List of Excel Logical Functions, References and Examples

by

Logic Functions in Excel check the data and return the result «TRUE» if the condition is true, and «FALSE» if not.

Here’s a full list of Built-In Logical Functions in Excel and their Descriptions below:

Click each of the function link to see detailed example.

Boolean Operator Functions

AND Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise
OR Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise
XOR Returns a logical Exclusive Or of all arguments (New in Excel 2013)
NOT Returns a logical value that is the opposite of a user supplied logical value or expression
(i.e. returns FALSE is the supplied argument is TRUE and returns TRUE if the supplied argument is FALSE)

Functions Returning Constant Values

TRUE Returns the logical value TRUE
FALSE Returns the logical value FALSE
Conditional Functions
IF Tests a user-defined condition and returns one result if the condition is TRUE, and another result if the condition is FALSE
IFERROR Tests if an initial supplied value (or expression) returns an error, and if so, returns a supplied value; Otherwise the function returns the initial value. (New in Excel 2007)
IFNA Tests if an expression returns the #N/A error and if so, returns an alternative specified value; Otherwise the function returns the value of the supplied expression. (New in Excel 2013)
IFS Tests a number of supplied conditions and returns a result corresponding to the first condition that evaluates to TRUE. (New in Excel 2016 – not available in Excel 2016 for Mac)
SWITCH Compares a number of supplied values to a supplied test expression and returns a result corresponding to the first value that matches the test expression. (New in Excel 2016 – not available in Excel 2016 for Mac)

Post navigation

Previous Post:

VLOOKUP without #N/A error 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 function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel OR Function
  • SWITCH function example in Excel
  • Invoice status with nested if in Excel

Date Time

  • Convert Excel time to decimal minutes
  • Get work hours between dates and times in Excel
  • Get month from date in Excel
  • How to calculate nth day of year in Excel
  • Series of dates by day

Grouping

  • How to randomly assign people to groups in Excel
  • Categorize text with keywords in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers at uneven intervals in Excel
  • Running count group by n size in Excel

General

  • 231 Keyboard Shortcut Keys In Excel
  • Check if multiple cells have same value in Excel
  • How to get amount with percentage in Excel
  • Using Existing Templates in Excel
  • How to Create Calendar in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning