ERFC function

PRO BASIC

The ERFC function in Jspreadsheet Formulas Pro is a mathematical tool that provides the complementary error function of a given number, defined as 1 − ERF(x). Essentially, this means it subtracts the error function of that number from 1. This function plays a crucial role in statistical analysis and probability within Jspreadsheet, allowing for more complex calculations and data interpretations.

Documentation

The ERFC function returns the complementary error function of a number, which is equal to 1 minus the error function of the same number.

Syntax

ERFC(x)

Parameter	Description
`x`	The number for which to calculate the complementary error function.

Behavior

The ERFC function is used to calculate the complementary ERF function integrated between a specified value 'x' and infinity. The function takes a single argument, which is a numerical value. Here is how it handles different types of inputs:

Empty Cells: If the 'ERFC' function is applied to an empty cell, it will return an error, as it requires a numerical input.
Text: If the function is applied to a cell containing non-numeric text, it will return an error, as it is not capable of converting text to numbers.
Booleans: If the function is applied to a cell containing a boolean value (TRUE or FALSE), the function will treat TRUE as 1 and FALSE as 0, and return a corresponding result.
Errors: If the supplied argument is an error, the 'ERFC' function will also return an error.
Non-Numeric Values: The 'ERFC' function expects a numeric input. If a non-numeric value is supplied, the function will return an error.

Common Errors

Error	Description
#VALUE!	This error is returned when the input to the 'ERFC' function is non-numeric, such as a text string.
#NUM!	This error is returned when the calculated result is a complex number, which is outside the scope of the 'ERFC' function.

Best practices

Always ensure that the input value to the 'ERFC' function is a numeric value to avoid errors.

Be aware that the 'ERFC' function is used for specific mathematical calculations related to the error function. Use it only if you understand its purpose and effects.

Handle errors appropriately using functions like 'IFERROR' to ensure your spreadsheet remains functional and easy to read.

Check your spreadsheet for any potential division by zero errors that may arise as a result of the values you provide to the 'ERFC' function.

Usage

A few examples using the ERFC function.

ERFC(0) → 1  
ERFC(1.5) → 0.033894854
ERFC(-1) → 1.842700793  
ERFC(TRUE) → Equivalent to ERFC(1) = 0.157299207 
ERFC(A2) → Calculates the complementary error function of the value in cell A2

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('OTU4YWQxMWFjNjg4ZmY0MmE0ZTJkMGI4ODliNGQyNGNjYjYyOGMxMGNiNmMxNDI3ZDI0YjUzMDc4YzNmYWE4NGI0MmFlODhiMmQwYTJiZGJhMTIzMjgyYjc5MTZlYjliYWFlMjEwYzQ1NThhNDUyNDhjNTI2MjNkYmU5Yzg5ZTIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNRGcyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Z-Score",
        "ERFC Value"
    ],
    [
        0,
        "=ERFC(A2)"
    ],
    [
        1,
        "=ERFC(A3)"
    ],
    [
        1.5,
        "=ERFC(A4)"
    ],
    [
        2,
        "=ERFC(A5)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('OTU4YWQxMWFjNjg4ZmY0MmE0ZTJkMGI4ODliNGQyNGNjYjYyOGMxMGNiNmMxNDI3ZDI0YjUzMDc4YzNmYWE4NGI0MmFlODhiMmQwYTJiZGJhMTIzMjgyYjc5MTZlYjliYWFlMjEwYzQ1NThhNDUyNDhjNTI2MjNkYmU5Yzg5ZTIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNRGcyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Z-Score",
        "ERFC Value"
    ],
    [
        0,
        "=ERFC(A2)"
    ],
    [
        1,
        "=ERFC(A3)"
    ],
    [
        1.5,
        "=ERFC(A4)"
    ],
    [
        2,
        "=ERFC(A5)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('OTU4YWQxMWFjNjg4ZmY0MmE0ZTJkMGI4ODliNGQyNGNjYjYyOGMxMGNiNmMxNDI3ZDI0YjUzMDc4YzNmYWE4NGI0MmFlODhiMmQwYTJiZGJhMTIzMjgyYjc5MTZlYjliYWFlMjEwYzQ1NThhNDUyNDhjNTI2MjNkYmU5Yzg5ZTIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNRGcyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Z-Score",
        "ERFC Value"
    ],
    [
        0,
        "=ERFC(A2)"
    ],
    [
        1,
        "=ERFC(A3)"
    ],
    [
        1.5,
        "=ERFC(A4)"
    ],
    [
        2,
        "=ERFC(A5)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('OTU4YWQxMWFjNjg4ZmY0MmE0ZTJkMGI4ODliNGQyNGNjYjYyOGMxMGNiNmMxNDI3ZDI0YjUzMDc4YzNmYWE4NGI0MmFlODhiMmQwYTJiZGJhMTIzMjgyYjc5MTZlYjliYWFlMjEwYzQ1NThhNDUyNDhjNTI2MjNkYmU5Yzg5ZTIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNRGcyTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Z-Score",
        "ERFC Value"
    ],
    [
        0,
        "=ERFC(A2)"
    ],
    [
        1,
        "=ERFC(A3)"
    ],
    [
        1.5,
        "=ERFC(A4)"
    ],
    [
        2,
        "=ERFC(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub