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

Month: May 2023

YEARFRAC

  • May 31, 2023
Definition: The YEARFRAC function in Excel is used to calculate the fraction of a year between two dates. Syntax: ==YEARFRAC(start_date, end_date, [basis]). Situation: This formula is appropriate in...
Read More

YEAR

  • May 31, 2023
Definition: The YEAR function in Excel is used to extract the year from a date. Syntax: ==YEAR(serial_number). Situation: This formula is appropriate in situations where you need to...
Read More

XOR

  • May 31, 2023
Definition: The XOR function in Excel is used to compare two logical expressions and returns TRUE if only one of the expressions is TRUE. Syntax: ==XOR(logical1, [logical2], ...)....
Read More

XNPV

  • May 31, 2023
Definition: The XNPV function in Excel is used to calculate the net present value of a series of cash flows that occur at irregular intervals. Syntax: ==XNPV(rate, values,...
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

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

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

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

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

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