The IFERROR Function
It returns a value you specify if a formula leads to an error. If there is no error in the formula IFERROR returns its result. It is part of the logical functions of Excel.
2504, 2019
Tag Archives: Logical
2504, 2019
The NOT Function
It returns the inverse of a logical value. If a logical value is TRUE it returns FALSE and vice versa. It is part of the logical functions of Excel.
2504, 2019
The IF Function
It is used to make logical comparisons between two values and return two results. One if the comparison is TRUE and one if the comparison is FALSE. It is part of the logical functions of Excel.
2504, 2019
The OR Function
It is used to determine if any of the conditions in its arguments is TRUE. If even one of its arguments is TRUE the function will return TRUE. It is part of the logical functions of Excel.
2504, 2019
The AND Function
It is used to determine if all the conditions in its arguments are TRUE. If even one of its arguments is FALSE the function will return FALSE. It is part of the logical functions of Excel.
1804, 2019
The SUMIFS Function
The SUMIFS function adds the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Mathematical functions of Excel.
1804, 2019
The COUNTIFS Function
The COUNTIFS function counts the number of times certain criterias are met. Even though its logical elements, it is part of the Statistical functions of Excel.
1804, 2019
The AVERAGEIFS Function
The AVERAGEIFS function returns the arithmetic mean (average) of all the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Statistical functions of Excel.
1604, 2019
Learn how to get the best out of the SUMIFS functions
Excel has provided us with several functions to help us make sense of huge pools of data. SUMIFS is one of them.
1604, 2019
Learn how to use the COUNTIFS function
Excel has provided us with several functions to help us make sense of huge pools of data. COUNTIFS is one of them.