Function: CHOOSE

Function: CHOOSE

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: LOOKUP

Function: LOOKUP

The Excel LOOKUP is a Lookup & Reference formula that can search a value inside a column or row, and return a matching value from the same position in another column or row. In this guide, we’re going to show you how to use the Excel LOOKUP function and also go...
Function: ISEVEN

Function: ISEVEN

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: ISODD

Function: ISODD

The ISODD Excel function is an Information formula that returns TRUE if the number argument is an odd number, or FALSE if it’s even. 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...
Function: ISREF

Function: ISREF

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: ISNONTEXT

Function: ISNONTEXT

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

Function: ISTEXT

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: ISNUMBER

Function: ISNUMBER

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