Logical functions

Excel's logical functions allow you to perform different actions based on the output of various logical statements. Take a look at our in-depth tutorials:

  • The TRUE and FALSE Excel functions. Use Excel's TRUE and FALSE functions to evaluate logical statements. These functions are the foundation of conditional formulas like IF.
  • Excel's logical operators. Logical operators within Excel enable you to evaluate whether statements are true using signs like 'equals', 'greater than', and 'less than'.
  • Excel's AND & OR functions. Excel's AND and OR functions allow you to check whether multiple logical statements are true. Combine them with IF statements for a powerful logic tool.
  • Excel's NOT function. The NOT function is a simple-to-use logical function that reverses whatever boolean expression it contains.
  • Using IF statements in Excel. Use IF statements in Excel to perform different actions depending on whether a given logical condition is met in a formula.
  • Excel's SUMIF function. Excel's SUMIF function allows you to take the sum of a column or row of data conditional upon a particular criteria row.
  • Excel's SUMIF with multiple criteria: SUMIFS. SUMIFS is very similar to Excel's SUMIF function, but it allows you to take the sum of a range based on multiple criteria rather than using a single conditional statement.
  • How to use Excel's COUNTIF function. The COUNTIF function allows you to count the number of occurrences of a specified criteria within a given cell range.
  • Using Excel's COUNTIFS function. COUNTIFS allows you to count the number of rows in a table that satisfy multiple criteria across as many columns as you want.
  • The AVERAGEIF function. AVERAGEIF, like its cousins SUMIF and COUNTIF, allows us to take the average of a range based on a specified criteria.
  • AVERAGEIF with multiple criteria: AVERAGEIFS. AVERAGEIFS is the multi-criteria version of the AVERAGEIF function, allowing us to AVERAGE a range based on multiple criteria.