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

Excel Formulas

TRANSPOSE

  • May 31, 2023
Definition: The TRANSPOSE function in Excel is used to transpose a range of cells. Syntax: ==TRANSPOSE(array). Situation: This formula is appropriate in situations where you need to transpose...
Read More

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

T.INV

  • May 31, 2023
Definition: The T.INV function in Excel is used to find the inverse of the left-tailed probability of the Student's t-distribution. Syntax: ==T.INV(probability, degrees_freedom). Situation: This formula is appropriate...
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