ERFC Excel Formula

Microsoft Excel is a spreadsheet program from Microsoft Corporation wherein it is the component of the Office group product for business applications. Commonly with its same products like Corel’s QuattroPro and Lotus 123, Microsoft Excel is considered an automated paper-based spreadsheet version. Thus, it makes it easier to process, manipulate and view the different data. Although, based on the report, Lotus 123 was the first spreadsheet software to introduce Macros and cell names. Microsoft Excel has implemented an interface graphical user and the ability to click and point using the mouse.  Microsoft Excel is often used to calculate, manipulate, analyze, arithmetic and mathematical formulation.

Conditional formatting is a kind of format setting on cells, which is based on the condition that is normally the cell value. Therefore, the user might have to do something such as putting the cell with color, which is different and if it’s more than a value. Through conditional formatting, the user could get the cells that calculate the results of the exam then displaying the word fail or pass. In Microsoft Excel, a reference is a type of data, which is referred as the rectangular cellblocks and a number of disjoint blocks of various cells. Excel uses a single type of reference cells on the present sheet, which is commonly known as the internal reference.

In external and internal references, external reference contains the worksheet ID which also describes on which cells are being referred to. Internal reference is having without reference inside the sheet and it is understood that this sheet is the current sheet. External and internal reference differs in description. Thus, the data type of external reference describes multiple disjoints blocks of various cells on its similar sheet. Internal reference can describe exclusively one block on its current sheet.  Any disjoint references can easily be passed to any different function taking the range argument.

Microsoft Excel has different functions and formulas wherein the user must have to study and learn to create easily data on the spreadsheet. Microsoft Excel has different basic functions, which are used for calculating, formulating, manipulating, analyzing, formatting, engineering calculations, arithmetic and mathematical functions. These functions and formulas easily give you the idea on how to solve any problems occurring in your spreadsheet. One of these functions is called the ERFC function in Microsoft Excel.

ERFC excel Function is a kind of Excel function, which returns the complementary ERF Excel function that integrates between the infinity and the x or the lower supplied limit. If ERFC function is not available, it returns the “#NAME?” error, the user must have to download or install the “Analysis ToolPak add-in”. The syntax for function is ERFC(x). X is the lower number bound to integrate ERF.


If “x” is non-numeric, ERFC takes back the error value of #VALUE!. If “x” is negative, ERFC takes back the error value of #NUM!. In the description of the ERFC function in Microsoft Excel, it takes back the ERF function, which is integrated along the infinity and the supplied lower limit.


  • #NUM! – this excel problem occurs in the Microsoft Excel or in the earlier version of the Microsoft Excel. It occurs when the supplied x value is negative.
  • #VALUE! – occurs when the supplied x is a non-numeric.
  • #NAME! – occurs when there is no downloaded Analysis ToolPak add-in or it is unable in your Microsoft Excel.

Post comment