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

Excel Formulas

ISERR

  • May 31, 2023
Definition: ISERR is a function that returns TRUE if a value is any error value except #N/A. Syntax: =ISERR(value) Situation: This formula is appropriate when you need to...
Read More

ISERROR

  • May 31, 2023
Definition: ISERROR is a function that returns TRUE if a value is any error value, including #N/A. Syntax: =ISERROR(value) Situation: This formula is appropriate when you need to...
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

HEX2OCT

  • May 31, 2023
Definition: HEX2OCT is a function that converts a hexadecimal number to octal. Syntax: =HEX2OCT(number, [places]) Situation: This formula is suitable when you need to convert a hexadecimal number...
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

HOUR

  • May 31, 2023
Definition: HOUR is a function that returns the hour component of a time value. Syntax: =HOUR(serial_number) Situation: This formula is suitable when you need to find the hour...
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

HYPERLINK

  • May 31, 2023
Definition: HYPERLINK is a function that creates a hyperlink to a specified location. Syntax: =HYPERLINK(link_location, [friendly_name]) Situation: This formula is suitable when you need to create a hyperlink...
Read More