Basic Description

The Excel ERF.PRECISE function calculates the Error Function, integrated between a supplied lower or upper limit and 0. The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, it is similar to the Erf function, which is available in earlier versions of Excel.

Syntax: ERF.PRECISE( x )
where x is the supplied lower or upper integral limit.

Erf.Precise Function Examples

The spreadsheet on the right shows the Excel Erf.Precise function used to calculate the integral of the Error Function between 0 and a supplied lower or upper limit. The top spreadsheet shows the format of the functions and the lower spreadsheet shows the function results.


Examples of use of the Excel Erf.Precise Function


Excel Erf.Precise Function Results


Erf.Precise Function Common Error

If you get an error from the Excel Erf.Precise function this is likely to be the #VALUE! error :

#VALUE! Occurs if the supplied argument, x, is non-numeric

2 thoughts on “ERF.PRECISE Function

  1. What’s Going down i’m new to this, I stumbled upon this I’ve found It absolutely helpful and it has helped me out loads. I’m hoping to contribute & assist other customers like its aided me. Good job.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment