![]() |
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_limit | The 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 |
|
| Functions - E | Index - E | Office Online 2013 | 2010 | 2007 | 2003 |
| © 2013 Better Solutions Limited. All Rights Reserved. | Top | 03-Jan-2013 |