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 ERF.PRECISE function is similar to the ERF function, which is available in earlier versions of Excel. In this guide, we’re going to show you how to use the ERF.PRECISE function and also go over some tips and error handling methods.


Supported versions

  • Excel 2010 and later

Excel ERF PRECISE Function Syntax

ERF(lower_limit, [upper_limit])


Arguments

x The lower bound of the integral.

ERF PRECISE Example

The x is the only required argument for the ERF.PRECISE (ERF PRECISE) function. Using this function, you can calculate the integral of the error function between 0 and a numeric value specified with the x argument. Note that the ERF.PRECISE function can also accept negative numerical values. Below is a set of examples that demonstrate some simple use cases:

=ERF.PRECISE(1) integrates between 0 and 1

=ERF.PRECISE(-2) integrates between -2 and 0

Download Workbook


Tips

  • Other related Excel functions:
    • ERF returns the error function between the entered arguments, and is the predecessor of the ERF.PRECISE (ERF PRECISE) function.
    • ERFC and ERFC.PRECISE functions return the complementary error function integrated between x and infinity (Both functions work very similarly. The ERFC.PRECISE function was added for the sake of consistency between function names.).
  • Please see the related Wikipedia page for further details on this function: Wikipedia’s Error Function

Issues

  • If x is a non-numeric value, the ERF.PRECISE returns the #VALUE! error.