How to create a dynamic drop down list Excel using the UNIQUE and FILTER functions
A dynamic drop down (also known as a dependent drop down) is a term for drop downs with a dynamic list. The list items of a dynamic drop down get updated according to another input which is usually another drop down as well. A common example is to have lots of items...
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
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 the...
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
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
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
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 value using this...
Function: ISLOGICAL
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 useful in...
Function: ISERROR
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. This formula...