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

Excel Formulas

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

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

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

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

UNICHAR

  • May 31, 2023
Definition: The UNICHAR function in Excel is used to return the Unicode character that corresponds to a number. Syntax: ==UNICHAR(number). Situation: This formula is appropriate in situations where...
Read More

UNICODE

  • May 31, 2023
Definition: The UNICODE function in Excel is used to return the Unicode code of a character. Syntax: ==UNICODE(text). Situation: This formula is appropriate in situations where you need...
Read More

UPPER

  • May 31, 2023
Definition: The UPPER function in Excel is used to convert text to uppercase. Syntax: ==UPPER(text). Situation: This formula is appropriate in situations where you need to convert text...
Read More

VALUE

  • May 31, 2023
Definition: The VALUE function in Excel is used to convert a text string that represents a number to a numerical value that Excel can recognize as a number....
Read More

VAR

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

VARA

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