Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Month: May 2023

AVERAGEIFS

  • May 31, 2023
Definition: AVERAGEIFS is a function that returns the average of a range of cells that meet multiple specified criteria. Syntax: =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...) Situation: This...
Read More

AVERAGEIF

  • May 31, 2023
Definition: AVERAGEIF is a function that returns the average of a range of cells that meet a specified criterion. Syntax: =AVERAGEIF(range, criteria, [average_range]) Situation: This formula is suitable...
Read More

AVERAGEA

  • May 31, 2023
Definition: AVERAGEA is a function that returns the arithmetic mean of a list of values, including text and logical values. Syntax: =AVERAGEA(value1, [value2], ...) Situation: This formula is...
Read More

AVERAGE

  • May 31, 2023
Definition: AVERAGE is a function that returns the arithmetic mean of a list of numbers. Syntax: =AVERAGE(number1, [number2], ...) Situation: This formula is suitable when you need to...
Read More

AVEDEV

  • May 31, 2023
Definition: AVEDEV is a function that returns the average of the absolute deviations of data points from their mean. Syntax: =AVEDEV(number1, [number2], ...) Situation: This formula is suitable...
Read More

ATANH

  • May 31, 2023
Definition: ATANH is a function that returns the inverse hyperbolic tangent of a number. The inverse hyperbolic tangent of a number is the value whose hyperbolic tangent is...
Read More

ATAN2

  • May 31, 2023
Definition: ATAN2 is a function that returns the arctangent of the quotient of two numbers. Syntax: =ATAN2(x_num, y_num) Situation: This formula is suitable when you need to find...
Read More

ATAN

  • May 31, 2023
Definition: ATAN is a function that returns the inverse tangent of a number. The inverse tangent of a number is the angle whose tangent is a given number....
Read More

ASINH

  • May 31, 2023
Definition: ASINH is a function that returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine of a number is the value whose hyperbolic sine is...
Read More

ASIN

  • May 31, 2023
Definition: ASIN is a function that returns the inverse sine of a number. The inverse sine of a number is the angle whose sine is a given number....
Read More