Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 18 of 30 · 270 articles
Function: WEBSERVICE
In this guide, we’re going to show you how to use the WEBSERVICE function and also go over some tips and error handling methods.
Excel Nested IF Alternative: The CHOOSE Function
In this article, we’re going to show you how to use the CHOOSE function as an Excel nested IF alternative and also go over some examples.
How to perform reverse lookup with CHOOSE function
In this guide, we are going to show you how to perform an Excel reverse lookup using the CHOOSE function, instead of the traditional VLOOKUP.
Function: CHOOSE
In this guide, we’re going to show you how to use the Excel CHOOSE function and also go over some tips and error handling methods.
How to create a dynamic drop down list Excel using the UNIQUE and FILTER functions
In this article, we are going to show you how to create a dynamic drop down list Excel using the dynamic array functions UNIQUE and FILTER.
Function: ISEVEN
In this guide, we’re going to show you how to use the Excel ISEVEN function and also go over some tips and error handling methods.
Function: ISREF
In this guide, we’re going to show you how to use the Excel ISREF function and also go over some tips and error handling methods.
Function: ISTEXT
In this guide, we’re going to show you how to use the ISTEXT Excel function and also go over some tips and error handling methods.
Function: ISLOGICAL
In this guide, we’re going to show you how to use the Excel ISLOGICAL function and also go over some tips and error handling methods.