Cellgrids Cellgrids
Home › Excel formulas › Engineering › ERF

ERF Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

ERF is an Excel Engineering function. Returns the error function, used in probability and statistics.

ERF syntax

=ERF(lower_limit, [upper_limit])

Arguments

When to use ERF

A specialized function used in scientific and engineering calculations rather than typical day-to-day business reporting.

Practice ERF online, free

Open the live Excel-style spreadsheet and try ERF yourself. No Excel install or sign-up needed to start.

Practice ERF now →

More Engineering functions

Frequently asked questions

What does the ERF function do in Excel?

Returns the error function, used in probability and statistics.

What is the syntax of ERF in Excel?

The syntax is =ERF(lower_limit, [upper_limit]). lower_limit: The lower bound of the range; upper_limit: The upper bound of the range (optional).

Where can I practice ERF online for free?

Open the free live spreadsheet on Cellgrids and try ERF yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Engineering functions · Excel case studies · Excel tutorials · Excel shortcuts