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

Month: May 2023

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

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

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

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

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

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

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

TYPE

  • May 31, 2023
Definition: The TYPE function in Excel is used to determine the data type of a value. Syntax: ==TYPE(value). Situation: This formula is appropriate in situations where you need...
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

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