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

Math

TRUNC

  • May 31, 2023
Definition: The TRUNC function in Excel is used to truncate a number to an integer by removing the decimal portion of the number. Syntax: ==TRUNC(number, [num_digits]). Situation: This...
Read More

SUMPRODUCT

  • May 31, 2023
Definition: The SUMPRODUCT function in Excel is used to find the sum of the product of two or more arrays. Syntax: ==SUMPRODUCT(array1, [array2], ...). Situation: This formula is...
Read More

SUMSQ

  • May 31, 2023
Definition: The SUMSQ function in Excel is used to find the sum of the squares of a range of data. Syntax: ==SUMSQ(number1, [number2], ...). Situation: This formula is...
Read More

SQRT

  • May 31, 2023
Definition: The SQRT function in Excel is used to find the square root of a number. Syntax: ==SQRT(number). Situation: This formula is appropriate in situations where you need...
Read More

SUBTOTAL

  • May 31, 2023
Definition: The SUBTOTAL function in Excel is used to calculate a subtotal for a range of data using a specified function. Syntax: ==SUBTOTAL(function_num, range). Situation: This formula is...
Read More

SUM

  • May 31, 2023
Definition: The SUM function in Excel is used to find the sum of a range of data. Syntax: ==SUM(number1, [number2], ...). Situation: This formula is appropriate in situations...
Read More

SUMIF

  • May 31, 2023
Definition: The SUMIF function in Excel is used to find the sum of a range of data that meets a specified criteria. Syntax: ==SUMIF(range, criteria, [sum_range]). Situation: This...
Read More

SUMIFS

  • May 31, 2023
Definition: The SUMIFS function in Excel is used to find the sum of a range of data that meets multiple specified criteria. Syntax: ==SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],...
Read More

OCT2BIN

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

OCT2DEC

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