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

Conditional

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

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

IFS

  • May 31, 2023
Definition: IFS is a function that evaluates multiple conditions and returns a value corresponding to the first true condition. Syntax: =IFS(condition1, value1, [condition2, value2], ...) Situation: This formula...
Read More

ISBLANK

  • May 31, 2023
Definition: ISBLANK is a function that returns TRUE if a cell is empty, and FALSE if it contains any value, including zero or a formula that returns an...
Read More

ISEVEN

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

ISFORMULA

  • May 31, 2023
Definition: ISFORMULA is a function that returns TRUE if a cell contains a formula, and FALSE if it does not. Syntax: =ISFORMULA(value) Situation: This formula is appropriate when...
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

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

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

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