Excel OR Function
The Excel OR function tests whether any arguments are TRUE, and returns TRUE if at least one argument is TRUE. If all arguments are FALSE the OR function will return FALSE.
0 Comments
January 24, 2021
Excel AND function
The Excel AND function tests whether all arguments are TRUE, and returns TRUE if all arguments are TRUE, or FALSE if any arguments are FALSE.
December 30, 2020
Excel IFERROR function
The Excel IFERROR function returns a specified value if the expression is an error. The IFERROR function is an Excel logical function.
December 28, 2020
Excel MAX IF formula
The MAX IF formula finds the maximum value from a range when a specific condition is met.
November 6, 2020
Excel AVERAGEIF function
The Excel AVERAGEIF function calculates the average value from a range of cells with a given condition. The AVERAGEIF function is useful for calculating the average of subset of an overall dataset (with a single criteria).
October 30, 2020
Excel AVERAGEIFS function
The Excel AVERAGEIFS function calculates the average value from a range of cells with a given condition or multiple conditions.
October 28, 2020
Excel COUNTIFS function
The Excel COUNTIFS function counts the number of occurrences of a condition or multiple conditions within a range of cells.
October 12, 2020
Excel COUNTIF function
The Excel COUNTIF function counts the number of occurrences of a condition within a range of cells. The COUNTIF function is useful for quickly counting instances of data within a dataset.
October 10, 2020
Excel SUMIFS function
The Excel SUMIFS function adds numerical values from a range of cells when certain condition(s) are true. The SUMIFS function is useful for summing specific subsets of data with one or more specific criteria.
October 8, 2020
Excel SUMIF function
The Excel SUMIF function adds numerical values from a range of cells when a condition is true. The SUMIF function is useful for summing specific subsets of data.
October 7, 2020