by Ilker | Jul 9, 2019 | Excel Formulas

The Excel ISREF function is an Information formula that returns TRUE if its argument is a reference, and FALSE otherwise. You can test the result of a formula or value of a cell using this function. this function can be especially useful in validation, formula...
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 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 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...
by Ilker | Jun 26, 2019 | Excel Formulas

The Excel ISBLANK function is an Information formula that returns TRUE if the reference cell is completely empty, and FALSE otherwise. As the name suggests, the formula asks the “Is X blank?” question to its argument. Although a cell must be completely...
by Ilker | Jun 26, 2019 | Excel Formulas

The Excel CONVERT function is an Engineering function that converts a number between unit systems. You can convert feet into meters, pounds into kilograms, gallons into liters Fahrenheit into Celsius, and so on with this formula. In this guide, we’re going to show you...