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

Blog

LARGE

  • May 31, 2023
Definition: LARGE is a function that returns the nth largest value in a data set. Syntax: =LARGE(array, k) Situation: This formula is appropriate when you need to find...
Read More

KURT

  • May 31, 2023
Definition: KURT is a function that returns the kurtosis of a data set, which is a measure of the peakedness and tails of the distribution. Syntax: =KURT(number1, [number2],...
Read More

JIS

  • May 31, 2023
Definition: JIS is a function that converts a double-byte character set (DBCS) code to a single-byte character set (SBCS) code. Syntax: =JIS(text) Situation: This formula is appropriate when...
Read More

ISTEXT

  • May 31, 2023
Definition: ISTEXT is a function that returns TRUE if a value is text, and FALSE if it is not. Syntax: =ISTEXT(value) Situation: This formula is appropriate when you...
Read More

ISREF

  • May 31, 2023
Definition: ISREF is a function that returns TRUE if a value is a reference, and FALSE if it is not. Syntax: =ISREF(value) Situation: This formula is appropriate when...
Read More

ISODD

  • May 31, 2023
Definition: ISODD is a function that returns TRUE if a number is odd, and FALSE if it is even. Syntax: =ISODD(value) Situation: This formula is appropriate when you...
Read More

ISNUMBER

  • May 31, 2023
Definition: ISNUMBER is a function that returns TRUE if a value is a number, and FALSE if it is not. Syntax: =ISNUMBER(value) Situation: This formula is appropriate when...
Read More

ISNONTEXT

  • May 31, 2023
Definition: ISNONTEXT is a function that returns TRUE if a value is not text, and FALSE if it is text. Syntax: =ISNONTEXT(value) Situation: This formula is appropriate when...
Read More

ISNA

  • May 31, 2023
Definition: ISNA is a function that returns TRUE if a value is #N/A, and FALSE if it is any other value. Syntax: =ISNA(value) Situation: This formula is appropriate...
Read More

ISLOGICAL

  • May 31, 2023
Definition: ISLOGICAL is a function that returns TRUE if a value is a logical value (TRUE or FALSE), and FALSE if it is not. Syntax: =ISLOGICAL(value) Situation: This...
Read More