Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Engineering > ERF

 

ERF(lower_limit [,upper_limit])

 
 Returns the error function integrated between lower_limit and upper_limit.

 lower_limitThe lower bound for integrating ERF.
 upper_limitThe upper bound for integrating ERF.

 REMARKS
 
  • This function is only available if you have the Analysis ToolPak add-in installed.
     
  • If any of the arguments are not numeric, then #VALUE! is returned.
     
  • If "lower_limit" < 0, then #NUM! 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.745) = 0.708
    2=ERF(0,1) = 0.843
    3=ERF(1) = 0.843
    4=ERF(1,) = 0.843
    5=ERF(1,5) = 0.157
    6=ERF(1,0) = -0.843
    7=ERF(,2) = #N/A
    8=ERF(1,-5) = #NUM!
    9=ERF(-1,5) = #NUM!
     

     Functions - E | Index - E | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top