Category: Information

ISERR function

This function allows you to test an expression and returns TRUE if your given expression results in any error apart from #N/A. For this function the #DIV/0, #NAME, #NULL!, #NUM!, #REF!, or #VALUE! errors all result in TRUE and...

Read More

ISERROR function

This function allows you to test a expression and returns TRUE if your given expression results in an error (#DIV/0, #N/A, #NAME, #NULL!, #NUM!, #REF!, or #VALUE!) and FALSE otherwise.   Syntax   ISERROR(Value)  ...

Read More

ISNUMBER function

This function will test if a value is numerical and return TRUE if it is a number and FALSE if it’s not.   Syntax   ISNUMBER(Value) Value (required) – This is the value you want to test if it’s a...

Read More

ISTEXT function

This function will test if a value is text and return TRUE if it is text and FALSE if it’s not.   Syntax   ISTEXT(Value) Value (required) – This is the value you want to test if it’s text.  ...

Read More
Loading

Abu

Follow

Consulting

Newsletter

Excel Insights

Excel Functions eBook

Microsoft MVP

Categories

Advertisement

Newsletter

Pin It on Pinterest