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

Error Handling

NA

  • May 31, 2023
Definition: NA is a function that returns the error value #N/A, which indicates that a value is not available or not applicable. Syntax: =NA() Situation: This formula is...
Read More

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

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

ERROR.TYPE

  • May 31, 2023
Definition: ERROR.TYPE is a function that returns a number corresponding to the type of error value in a cell. Syntax: =ERROR.TYPE(error_val) Situation: This formula is suitable when you...
Read More