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

Excel Formulas

VARP

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

VARPA

  • May 31, 2023
Definition: The VARPA function in Excel is used to find the variance of a population of data that contains text or logical values. Syntax: ==VARPA(number1, [number2], ...). Situation:...
Read More

VDB

  • May 31, 2023
Definition: The VDB function in Excel is used to calculate the depreciation of an asset for a specific period using the variable declining balance method. Syntax: ==VDB(cost, salvage,...
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

WEEKDAY

  • May 31, 2023
Definition: The WEEKDAY function in Excel is used to return the day of the week for a given date. Syntax: ==WEEKDAY(serial_number, [return_type]). Situation: This formula is appropriate in...
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

WEIBULL

  • May 31, 2023
Definition: The WEIBULL function in Excel is used to find the Weibull distribution of a set of data. Syntax: ==WEIBULL(x, alpha, beta, [cumulative]). Situation: This formula is appropriate...
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

WORKDAY

  • May 31, 2023
Definition: The WORKDAY function in Excel is used to calculate the date that is a specific number of workdays from a given date. Syntax: ==WORKDAY(start_date, days, [holidays]). Situation:...
Read More

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