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

Excel Formulas

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

TBILLYIELD

  • May 31, 2023
Definition: The TBILLYIELD function in Excel is used to calculate the yield of a US Treasury bill. Syntax: ==TBILLYIELD(settlement, maturity, price). Situation: This formula is appropriate in situations...
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

TDIST

  • May 31, 2023
Definition: The TDIST function in Excel is used to calculate the two-tailed probability of the Student's t-distribution. Syntax: ==TDIST(x, degrees_freedom, tails). Situation: This formula is appropriate in situations...
Read More

SUMX2MY2

  • May 31, 2023
Definition: The SUMX2MY2 function in Excel is used to find the sum of the difference between squares of two corresponding arrays. Syntax: ==SUMX2MY2(array_x, array_y). Situation: This formula is...
Read More

TEXT

  • May 31, 2023
Definition: The TEXT function in Excel is used to convert a value to text in a specific format. Syntax: ==TEXT(value, format_text). Situation: This formula is appropriate in situations...
Read More

SUMX2PY2

  • May 31, 2023
Definition: The SUMX2PY2 function in Excel is used to find the sum of the sum of squares of two corresponding arrays. Syntax: ==SUMX2PY2(array_x, array_y). Situation: This formula is...
Read More

TIME

  • May 31, 2023
Definition: The TIME function in Excel is used to create a time with hour, minute, and second values. Syntax: ==TIME(hour, minute, second). Situation: This formula is appropriate in...
Read More

SUMXMY2

  • May 31, 2023
Definition: The SUMXMY2 function in Excel is used to find the sum of the square of the difference between corresponding values in two arrays. Syntax: ==SUMXMY2(array_x, array_y). Situation:...
Read More

SYD

  • May 31, 2023
Definition: The SYD function in Excel is used to calculate the depreciation of an asset for a specified period using the sum of the years' digits method. Syntax:...
Read More