by Ilker | Jul 8, 2019 | Excel Formulas

The Excel ISNONTEXT function is an Information formula that returns TRUE if the input value is a not text value, and FALSE otherwise. You can test the result of a formula or value of a cell using this function. This formula can be especially useful in organizing data,...
by Ilker | Jul 8, 2019 | Excel Formulas

The ISTEXT Excel function is an Information formula that returns TRUE if the input value is a text string, and FALSE otherwise. You can test the result of a formula or value of a cell using this function. This formula can be especially useful in error handling,...
by Ilker | Jul 2, 2019 | Excel Tips & Tricks

Excel doesn’t have a built-in method to sort data randomly. Instead, you need to rely on formulas to sort a list of values randomly. Before dynamic array formulas, you needed to build a structure of formulas and helper columns to achieve this. Thanks to the...
by Ilker | Jul 2, 2019 | Excel Macros, Excel Tips & Tricks

Macros in Excel are code blocks that you can run in your workbooks to process a batch of commands. Macros are great for automating repetitive tasks such as copying or removing data from specific cells. However, macros can be daunting for new users. Creating a macro is...
by Ilker | Jul 1, 2019 | Excel Formulas

The Excel ISNUMBER function is an Information formula that returns TRUE if value is a number, and FALSE if not. As the name suggests, the formula asks the question “Is number?” to its argument. This way, you can test the outcome of a formula or a cell...
by Ilker | Jul 1, 2019 | Excel Formulas

The Excel ISLOGICAL function is an Information formula that returns TRUE if the input is a logical value, and a FALSE result otherwise. As the name suggests, the formula asks the question “Is logical?” to the argument value. This formula can be especially...
by Ilker | Jun 28, 2019 | Excel Tips & Tricks

The Excel Developer tab is a Ribbon tab which contains a number of tools aimed towards advanced features of Excel such as VBA, add-ins, form and ActiveX controls. Although you can access the VBA Editor with the shortcut (Alt+F11), the Developer tab in the Ribbon also...
by Ilker | Jun 28, 2019 | Excel Formulas

The ISERROR Excel function is an Information formula that returns TRUE if the target value contains an error value, and FALSE if it does not. As the name suggests, the formula asks the question “Is error?” to its argument, and returns a Boolean result....
by Ilker | Jun 27, 2019 | Excel Formulas

The ISERR Excel function is an Information formula that returns TRUE, if the reference value is an error code (except for #N/A), and FALSE otherwise. As the name suggests, the formula asks the “Is error?” question, and can be especially useful for...