Practice free

ERF.PRECISE function

ERF.PRECISE returns the error function integrated from 0 to a single value. It is a one-argument version of ERF with improved accuracy and does not accept a lower limit.

Example

Read it as a sentence: find the error function value for 1, which gives 0.842700792949715.

Practice this in the app

Syntax

ERF.PRECISE(x)

x (required)
The upper limit of integration (lower is 0).

Returns: The error function integrated from 0 to x.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ERF.PRECISE(0.5) 0.520499878 0.5
=ERF.PRECISE(0) 0 0
=ERF.PRECISE(-0.5) -0.520499878 Negative
=ERF.PRECISE(10) 1 Large
=ERF.PRECISE("0.5") 0.520499878 Text number
=ERF.PRECISE({0.5,1}) 0.520499878 Spill
=ERF.PRECISE("a") #VALUE! Text
=ERF.PRECISE(TRUE) #VALUE! TRUE

Watch out for

  • Does not accept a lower limit; use ERF for that.

Where it works

Excel
ERF.PRECISE arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Engineering functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .