Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Engineering > ERFC
 

ERFC(x)

 
 Returns the complementary ERF function integrated between x and infinity.

 xThe lower bound for integrating ERF.

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• If "x" is not numeric, then #VALUE! is returned.
     
  		• If "x" < 0, then #NUM! is returned.

     EXAMPLES
     
     A
    1=ERFC(0.02) = 0.977
    2=ERFC(1) = 0.157
    3=ERFC(1.3) = 0.066
    4=ERFC(2) = 0.005
    5=ERFC(5) = 0.000
    6=ERFC(1.11) = 0.116
    7=ERFC(-1) = #NUM!
    8=ERFC("some text") = #VALUE!
    		 
     Functions - E | Index - E | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top