Function: ERF.PRECISE

Function: ERF.PRECISE

by | Jul 29, 2019

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

Function: ERF

by | Jul 22, 2019

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....
Excel Comparison Operators

Excel Comparison Operators

by | Jul 19, 2019

Excel comparison operators can compare two values and return a logical (Boolean) value. You can use the return logical value in other functions like IF, or features, like Conditional Formatting, that require a logical value input. In this guide, we are going to show...
How to insert today's date in Excel

How to insert today's date in Excel

by | Jul 19, 2019

Using the current time and/or date in Excel can help keep track of activities or add timestamps to your work easily. In Excel, there are a few ways for inserting the current date and time in a cell. In this article, we are going to show you how to insert Excel...
Function: ENCODEURL

Function: ENCODEURL

by | Jul 17, 2019

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

Function: FILTERXML

by | Jul 17, 2019

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

Function: WEBSERVICE

by | Jul 17, 2019

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

Excel Nested IF Alternative: The CHOOSE Function

by | Jul 16, 2019

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