Function: WEBSERVICE

Function: WEBSERVICE

by | Jul 17, 2019

The Excel WEBSERVICE function is a Web formula that can return data from a web service on the Internet or an Intranet. This function is available for 2013 and later versions of Excel for Windows. In this guide, we’re going to show you how to use the Excel WEBSERVICE...
Excel Nested IF Alternative: The CHOOSE Function

Excel Nested IF Alternative: The CHOOSE Function

by | Jul 16, 2019

A popular use case for the IF function is creating nested formulas that can check for various criteria. However, nested IF statements can get pretty complicated and cumbersome when dealing with several conditions. In this article, we’re going to show you how to use...
How to perform reverse lookup with CHOOSE function

How to perform reverse lookup with CHOOSE function

by | Jul 16, 2019

Lookup functions are widely used in Excel models. However, one of the most popular lookup functions, VLOOKUP, can only search the left-most column in the search area. This function will fall short if you need to search in the middle of a table and return values from...
Function: CHOOSE

Function: CHOOSE

by | Jul 15, 2019

The Excel CHOOSE function is a Lookup & Reference formula that can return the value of one of its arguments by a given position. For example, if the value arguments are the months of a year, the CHOOSE function can return one of the months, when a number between 1...
Function: ISEVEN

Function: ISEVEN

by | Jul 10, 2019

The Excel ISEVEN function is an Information formula that returns TRUE if the number input is even, and FALSE if it is odd. You can test the result of a formula or value of a cell using this function. In this guide, we’re going to show you how to use the Excel ISEVEN...
Function: ISREF

Function: ISREF

by | Jul 9, 2019

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...
Function: ISTEXT

Function: ISTEXT

by | Jul 8, 2019

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,...
Function: ISLOGICAL

Function: ISLOGICAL

by | Jul 1, 2019

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...