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

Follow Us

Advertisement

Free Book

Categories

Advertisement

Pin It on Pinterest