by Ilker | Jul 17, 2019 | Excel Formulas
The Excel ENCODEURL function is a Web formula that can convert strings into their URL-encoded versions. The ENCODEURL function is available for 2013 and later versions of Excel on the Windows platform. In this guide, we’re going to show you how to use the Excel...
by Ilker | Jul 17, 2019 | Excel Formulas
The FILTERXML function is a Web formula that can return specific data from an XML content, using a given XPath. This ability makes the function suitable for use in conjunction with the WEBSERVICE function. The FILTERXML function is available for 2013 and later...
by Ilker | Jul 17, 2019 | Excel Formulas
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...
by Ilker | Jul 16, 2019 | Excel Formulas, Excel Tips & Tricks
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...
by Ilker | Jul 16, 2019 | Excel Formulas, Excel Tips & Tricks
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...
by Ilker | Jul 15, 2019 | Excel Formulas
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...
by Ilker | Jul 15, 2019 | Excel Formulas
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...
by Ilker | Jul 10, 2019 | Excel Formulas
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...
by Ilker | Jul 9, 2019 | Excel Formulas
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...