 Function: ERF.PRECISE

The Excel ERF.PRECISE (ERF PRECISE) function is an Engineering formula that calculates and returns the error function, integrated between a limit and zero (0). This function has been introduced Excel 2010, and is not available in earlier versions. However, the... Function: ERFC.PRECISE

The Excel ERFC.PRECISE (ERFC PRECISE) function is an Engineering formula that calculates and returns the complementary error function, integrated between a specified lower limit and infinity. This function has been introduced Excel 2010, and is not available in... Function: ERFC

The ERFC function is an Engineering formula that calculates and returns the complementary error function, integrated between a lower limit and infinity. This formula essentially a subset of the error functions that calculate the probability of a value falling into a... Function: ERF

The ERF function is an Engineering formula that calculates and returns the error function, integrated between specified lower and upper limits. In this guide, we’re going to show you how to use the ERF function, and also go over some tips and error handling methods.... Function: ENCODEURL

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

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

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

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

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