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

Blog

AREAS

  • May 31, 2023
Definition: AREAS is a function that returns the number of areas in a reference. Syntax: =AREAS(reference) Situation: This formula is suitable when you need to count the number...
Read More

ADDRESS

  • May 31, 2023
Definition: ADDRESS is a function that returns a cell reference as a string, based on a specified row and column number. Syntax: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) Situation:...
Read More

ACOSH

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

ACOS

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

ABS

  • May 31, 2023
Definition: ABS is a function that returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax: =ABS(number) Situation:...
Read More

IFERROR

  • May 26, 2023
The IFERROR formula is used to return a specific value if a formula returns an error. To use the IFERROR formula, select the cell where you want the...
Read More

MATCH

  • May 26, 2023
The MATCH formula is used to search for a value within a range of cells and return the relative position of the value within the range. To use...
Read More

INDEX

  • May 26, 2023
The INDEX formula is used to return a value from a specified cell within a range of cells. To use the INDEX formula, select the cell where you...
Read More

HLOOKUP

  • May 26, 2023
The HLOOKUP formula is used to search for a value in the first row of a range of cells and return a value in the same column from...
Read More

VLOOKUP

  • May 26, 2023
The VLOOKUP formula is used to search for a value in the first column of a range of cells and return a value in the same row from...
Read More