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

Month: May 2023

IFS

  • May 31, 2023
Definition: IFS is a function that evaluates multiple conditions and returns a value corresponding to the first true condition. Syntax: =IFS(condition1, value1, [condition2, value2], ...) Situation: This formula...
Read More

HYPGEOMDIST

  • May 31, 2023
Definition: HYPGEOMDIST is a function that returns the hypergeometric distribution for a specified set of parameters. Syntax: =HYPGEOMDIST(sample_s, number_sample, population_s, number_pop, [cumulative]) Situation: This formula is suitable when...
Read More

HYPERLINK

  • May 31, 2023
Definition: HYPERLINK is a function that creates a hyperlink to a specified location. Syntax: =HYPERLINK(link_location, [friendly_name]) Situation: This formula is suitable when you need to create a hyperlink...
Read More

HOUR

  • May 31, 2023
Definition: HOUR is a function that returns the hour component of a time value. Syntax: =HOUR(serial_number) Situation: This formula is suitable when you need to find the hour...
Read More

HEX2OCT

  • May 31, 2023
Definition: HEX2OCT is a function that converts a hexadecimal number to octal. Syntax: =HEX2OCT(number, [places]) Situation: This formula is suitable when you need to convert a hexadecimal number...
Read More

HEX2DEC

  • May 31, 2023
Definition: HEX2DEC is a function that converts a hexadecimal number to decimal. Syntax: =HEX2DEC(number) Situation: This formula is suitable when you need to convert a hexadecimal number to...
Read More

HEX2BIN

  • May 31, 2023
Definition: HEX2BIN is a function that converts a hexadecimal number to binary. Syntax: =HEX2BIN(number, [places]) Situation: This formula is suitable when you need to convert a hexadecimal number...
Read More

HARMEAN

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

GROWTH

  • May 31, 2023
Definition: GROWTH is a function that predicts a future value using exponential regression. Syntax: =GROWTH(known_y's, [known_x's], [new_x's], [const]) Situation: This formula is suitable when you need to predict...
Read More

GEOMEAN

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