ERF function

PRO BASIC

In Jspreadsheet Formulas Pro, the ERF function calculates the error function of a given number. This is a mathematical function that is often used in statistical analysis, particularly in the field of probability. To use it, you simply need to input the number you wish to calculate the error function for within the parentheses in the formula. This function then returns a corresponding value, providing insight into the statistical error associated with your original number.

Documentation

The ERF function returns the error function of a number.

Syntax

ERF(lower_limit, [upper_limit])

Parameter	Description
`lower_limit`	The lower bound for the calculation. If only this value is provided, the function returns the error function from zero to this value.
`[upper_limit]`	(Optional) The upper bound for the calculation. If provided, the function returns the error function from the lower limit to the upper limit.

Behavior

The ERF function is used to calculate the error function of a specific number. The function syntax is: ERF(lower_limit, [upper_limit]). If only a lower limit is provided, it calculates the error function from zero to the lower limit. If both lower and upper limits are provided, the function returns the integral of the error function between those boundaries.

Here's how it behaves with the following inputs:

Empty cells: If the cell reference is empty, the function treats it as zero.
Text: If the cell reference contains a text string, the function returns a #VALUE! error.
Booleans: If the cell reference contains a boolean value, it is implicitly coerced to numbers: TRUE as 1 and FALSE as 0.
Errors: If the cell reference contains an error, the function propagates the error.

Common Errors

Error	Description
#VALUE!	This error occurs when the given input is non-numeric.
#NUM!	This error is returned when the function encounters a calculation error.

Best practices

Always ensure that your input values are numerical. Text or non-numeric values will result in a #VALUE! error.

Make sure to check the range of your values. Very large values might result in a #NUM! error.

Be aware that the ERF function treats empty cells as zeros.

Use absolute cell references if you plan to copy your ERF function across multiple cells.

Usage

A few examples using the ERF function.

ERF(0) → 0  
ERF(1.5) → 0.966105146
ERF(-1, 1) → 1.685401586  
ERF(A2) → Calculates the error function of the value in cell A2  
ERF(2, 3) → Returns the error function value between 2 and 3

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('M2Y0MDllMzNlZjRkOTk1Y2NkOTM1MWU4YmQ3MDNhNjc3NWYxMmYyZWE3MzhiNjJkNzQ2MDU4ZDRjOGEwYmQ2MDBlOTJkNDA2NDRkZDc1ZjdmZTBhMDBhMzdhNWFmYjRhODkyZTY0MWM3ODk1OGNlZjBmMDlhYWZkNTM3NjY4OTMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Input Value",
        "Error Function"
    ],
    [
        0,
        "=ERF(A2)"
    ],
    [
        0.5,
        "=ERF(A3)"
    ],
    [
        1,
        "=ERF(A4)"
    ],
    [
        1.5,
        "=ERF(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('M2Y0MDllMzNlZjRkOTk1Y2NkOTM1MWU4YmQ3MDNhNjc3NWYxMmYyZWE3MzhiNjJkNzQ2MDU4ZDRjOGEwYmQ2MDBlOTJkNDA2NDRkZDc1ZjdmZTBhMDBhMzdhNWFmYjRhODkyZTY0MWM3ODk1OGNlZjBmMDlhYWZkNTM3NjY4OTMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Input Value",
        "Error Function"
    ],
    [
        0,
        "=ERF(A2)"
    ],
    [
        0.5,
        "=ERF(A3)"
    ],
    [
        1,
        "=ERF(A4)"
    ],
    [
        1.5,
        "=ERF(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('M2Y0MDllMzNlZjRkOTk1Y2NkOTM1MWU4YmQ3MDNhNjc3NWYxMmYyZWE3MzhiNjJkNzQ2MDU4ZDRjOGEwYmQ2MDBlOTJkNDA2NDRkZDc1ZjdmZTBhMDBhMzdhNWFmYjRhODkyZTY0MWM3ODk1OGNlZjBmMDlhYWZkNTM3NjY4OTMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Input Value",
        "Error Function"
    ],
    [
        0,
        "=ERF(A2)"
    ],
    [
        0.5,
        "=ERF(A3)"
    ],
    [
        1,
        "=ERF(A4)"
    ],
    [
        1.5,
        "=ERF(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('M2Y0MDllMzNlZjRkOTk1Y2NkOTM1MWU4YmQ3MDNhNjc3NWYxMmYyZWE3MzhiNjJkNzQ2MDU4ZDRjOGEwYmQ2MDBlOTJkNDA2NDRkZDc1ZjdmZTBhMDBhMzdhNWFmYjRhODkyZTY0MWM3ODk1OGNlZjBmMDlhYWZkNTM3NjY4OTMsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE5UQTBNVGt6TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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: [
    [
        "Input Value",
        "Error Function"
    ],
    [
        0,
        "=ERF(A2)"
    ],
    [
        0.5,
        "=ERF(A3)"
    ],
    [
        1,
        "=ERF(A4)"
    ],
    [
        1.5,
        "=ERF(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub