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

Free eBook

Recent Tweets

Categories

Pin It on Pinterest

50 Tips to Master Excel

Join our mailing list and get the FREE ebook!

40 plus keyboard shortcuts!

Packed with hidden features you won't find anywhere else!

Top time saving tips that will reduce your work!

Easy to follow illustrated tips!

Something for every level from beginner to pro!

Check your email to confirm subscription and receive your free book.