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

Blog

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

TODAY

  • May 31, 2023
Definition: The TODAY function in Excel is used to return the current date. Syntax: ==TODAY(). Situation: This formula is appropriate in situations where you need to get the...
Read More

TINV

  • May 31, 2023
Definition: The TINV function in Excel is used to find the value of t for a given probability and degrees of freedom for a Student's t-distribution. Syntax: ==TINV(probability,...
Read More

TIMEVALUE

  • May 31, 2023
Definition: The TIMEVALUE function in Excel is used to convert a text string that represents a time to a serial number that Excel can recognize as a time....
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

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

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

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

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

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