ERFC.PRECISE Function

Basic Description

The Excel ERFC.PRECISE function calculates the Complementary Error Function, integrated between a supplied lower limit and infinity. The function is new in Excel 2010 and so is not available in earlier versions of Excel. However, it is similar to the Erfc function, which is available in earlier versions of Excel.

Syntax: ERFC.PRECISE( x )

where x is the lower limit of the complementary error function integral.

 

Erfc.Precise Function Examples

The spreadsheets below show the Excel Erfc.Precise function used to calculate the Complementary Error Function between various supplied lower limits and infinity. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the function results.

 Formulas:

Examples of use of the Excel Erfc.Precise Function

 Results:

Excel Erfc.Precise Function Results

 

Erfc.Precise Function Common Error

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

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

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>

*

code

clearPost Comment