What is ERF function in Excel?
The ERF function is one of the Engineering functions of Excel.
It Calculates and Returns the error function.
We can find this function in ENGINEERING category of the insert function Tab.
How to use ERF function in excel
- Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.
4. Select ENGINEERING category.
5. Select ERF function.
6. Then select ok.

7. In the function arguments Tab you will see ERF function.
8. Lower_limit is the lower bound for integrating ERF.
9. Upper_limit is the upper bound for integrating ERF.
10. You will see the results in the formula result section.

Examples of ERF function in Excel

ERF related functions
- Use ERF.PRECISE function to Return the error function.
- Use ERFC function to return the complementary error function.
- Use ERFC.PRECISE function to return the complementary error function.