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

Excel Formulas

XIRR

  • May 31, 2023
Definition: The XIRR function in Excel is used to calculate the internal rate of return for a series of cash flows that occur at irregular intervals. Syntax: ==XIRR(values,...
Read More

TREND

  • May 31, 2023
Definition: The TREND function in Excel is used to calculate the linear trendline for a set of data. Syntax: ==TREND(known_y's, [known_x's], [new_x's], [const]). Situation: This formula is appropriate...
Read More

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

TYPE

  • May 31, 2023
Definition: The TYPE function in Excel is used to determine the data type of a value. Syntax: ==TYPE(value). Situation: This formula is appropriate in situations where you need...
Read More

T.INV.2T

  • May 31, 2023
Definition: The T.INV.2T function in Excel is used to find the inverse of the two-tailed probability of the Student's t-distribution. Syntax: ==T.INV.2T(probability, degrees_freedom). Situation: This formula is appropriate...
Read More

TAN

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

TANH

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

TBILLEQ

  • May 31, 2023
Definition: The TBILLEQ function in Excel is used to calculate the bond-equivalent yield for a US Treasury bill. Syntax: ==TBILLEQ(settlement, maturity, discount). Situation: This formula is appropriate in...
Read More

TBILLPRICE

  • May 31, 2023
Definition: The TBILLPRICE function in Excel is used to calculate the price per $100 face value of a US Treasury bill. Syntax: ==TBILLPRICE(settlement, maturity, discount). Situation: This formula...
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