What is the syntax for ERF in Excel?

The syntax for ERF is: =ERF(lower_limit, [upper_limit])

How do I use the ERF function?

To use ERF, type =ERF( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Why is ERF not working in my Excel?

Common issues with ERF include Must be numeric. Start by checking the syntax =ERF(lower_limit, [upper_limit]), then verify each referenced cell or range.

Engineering

ERF Function in Excel

Returns the error function integrated between lower_limit and upper_limit.

Syntax

=ERF(lower_limit, [upper_limit])

Arguments

lower_limit (required): Lower bound
upper_limit (optional): Upper bound

Examples

=ERF(1) - Error function at 1 - Result: 0.843

ERF in technical sheets

Document units in adjacent cells — many engineering functions require exact unit strings.
Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

Must be numeric

Use cases

Statistics
Engineering
Probability

Frequently asked questions

What is the ERF function in Excel? ERF returns the error function integrated between lower_limit and upper_limit. The syntax is =ERF(lower_limit, [upper_limit]). Typical use cases include statistics, engineering, probability.
How do I use the ERF function? To use ERF, type =ERF( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
Why is ERF not working in my Excel? Common issues with ERF include Must be numeric. Start by checking the syntax =ERF(lower_limit, [upper_limit]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.