ImportantThis function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. This function is still available for compatibility with earlier versions of Excel. However, if backward compatibility is not required, you should consider using the new functions from now on, because they more accurately describe their functionality.For more information about the new function, see the method. ErfC ( Arg1, Arg2)expression A variable that represents a object. Parameters NameRequired/OptionalData typeDescriptionArg1RequiredVariantThe first argument.Arg2OptionalVariantThe second argument.Return valueDouble RemarksIf this function is not available, and returns the #NAME? Error, you need to install and load the Analysis ToolPak add-in.If the parameter is nonnumeric, ErfC returns the #VALUE!
Error value.If the parameter is negative, ErfC returns the #NUM! ExampleThe following example displays the complementary Erf function of 1 (0.1573). =ERFC(1)Support and feedbackHave questions or feedback about Office VBA or this documentation? Please see for guidance about the ways you can receive support and provide feedback.
Inverse Erf Excel Vba Formula
. More than300 powerful advanced features, designed for1500 work scenarios, increasing productivity by70%, give you more time to take care of family and enjoy life. No longer need memorizing formulas and VBA codes, give your brain a rest from now on. Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds,. Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now. 110,000 highly effective people and 300+ world-renowned companies' choice.
Excel Vba Examples
60-day full features free trial. 60-day money back guarantees.
Inverse Erf Excel Vba Table
2 years of free upgrade and support. Try this:Sub InvertSelectionDim rng As RangeDim Rng1 As RangeDim Rng2 As RangeDim OutRng As RangeDim xTitleId As StringxTitleId = 'Invert Selection'Set Rng1 = Application.SelectionSet Rng1 = Application.InputBox('Range1:', xTitleId, Rng1.Address, Type:=8)Set Rng2 = Application.InputBox('Range2', xTitleId, Type:=8)For Each rng In Rng2If Application.Intersect(rng, Rng1) Is Nothing ThenIf OutRng Is Nothing ThenSet OutRng = rngElseSet OutRng = Application.Union(OutRng, rng)End IfEnd IfNextOutRng.SelectEnd Sub.