Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Engineering > ERF
 

ERF(lower_limit [,upper_limit])

 
 Returns the error function integrated between a lower limit and an upper limit.

 lower_limitThe lower bound for integrating ERF.
 upper_limit(Optional) The upper bound for integrating ERF.

 REMARKS
 
  		• In Excel 2007 (and later) this function has been removed from the Analysis ToolPak add-in and is available as standard.
     
  		• In Excel 2003 this function is only available when you have the Analysis ToolPak add-in loaded.
     
  		• In Excel 2010 the accuracy of this function was improved.
     
  		• In Excel 2007 the accuracy of this function was improved to use the internal calculations for gamma which might change the accuracy slightly (after 15 decimal places)
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.
     
  		• If "lower_limit" < 0, then #NUM! is returned.
     
  		• If "lower_limit" > "upper_limit", then #N/A is returned.
     
  		• If "lower_limit" is left blank, then #N/A is returned.
     
  		• If "upper_limit" < 0, then #NUM! is returned.
     
  		• If "upper_limit" is left blank, then it integrates between zero and "lower_limit".

     EXAMPLES
     
     A
    1=ERF(0.2) = 0.223
    2=ERF(0.745) = 0.708
    3=ERF(0,1) = 0.843
    4=ERF(1) = 0.843
    5=ERF(1,) = #N/A
    6=ERF(1,1) = 0
    7=ERF(1,5) = 0.157
    8=ERF(1,6) = 0.157
    9=ERF(1,7) = 0.157
    10=ERF(2,2) = 0.000
    11=ERF(2,4) = 0.005
    12=ERF(2,6) = 0.005
    13=ERF(1,0) = -0.843
    14=ERF(1,1) = 0.000
    15=ERF(,2) = #N/A
    16=ERF(1,-5) = -1.843
    17=ERF(-1,5) = 1.843
    18=ERF("some text",5) = #VALUE!
    		 
     Functions - E | Index - E | Office Online 2013 | 2010 | 2007 | 2003 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013