FACTDOUBLE function

PRO BASIC

The FACTDOUBLE function in Jspreadsheet Formulas Pro calculates the double factorial of a given number. It performs this by multiplying the specified number by every second preceding number until it reaches 1. For instance, if you input 5, it will calculate 531. This can be particularly useful in advanced mathematical operations and statistical analysis.

Documentation

Returns the product of all integers from the specified number down to 1 that have the same parity (odd or even) as the starting number.

Syntax

FACTDOUBLE(number)

Parameter	Description
`number`	The non-negative integer for which to calculate the double factorial.

Behavior

The FACTDOUBLE function calculates the double factorial of a given number. This means, for an input n, it calculates the product of all integers from n down to 1 with the same parity (odd or even). Here's how it handles different types of input:

Numbers: The function works optimally with non-negative integer inputs. For example, FACTDOUBLE(5) returns 15, since 531 = 15.
Text: If a text value is entered as an argument, the function returns a #VALUE! error.
Booleans: If a boolean value (TRUE or FALSE) is entered as an argument, the function converts the boolean to its numeric equivalent (1 for TRUE, 0 for FALSE) and returns the double factorial of the numeric equivalent.
Empty cells: If an empty cell is referenced as an argument, Jspreadsheet treats it as 0 and returns 1, since the double factorial of 0 is defined as 1.
Errors: If an error is referenced as an argument, the function returns the same error.
Negative numbers: If a negative number is provided as an argument, the function returns a #NUM! error.

Common Errors

Error	Description
#VALUE!	This error is returned when a text value is passed as an argument to the `FACTDOUBLE` function.
#NUM!	This error is returned when a negative number is passed as an argument to the `FACTDOUBLE` function.
#N/A	This error is returned when an invalid or missing reference is used as an argument.

Best practices

Always ensure that the argument passed to the FACTDOUBLE function is a non-negative integer. The function does not support text or negative numbers.

Be cautious when referencing cells as arguments. If the referenced cell contains a text value or an error, the FACTDOUBLE function will return an error.

Use the ISNUMBER function to validate inputs to the FACTDOUBLE function. This can help prevent unexpected errors.

Remember that the FACTDOUBLE function calculates the double factorial, not the standard factorial. For the standard factorial, use the FACT function instead.

Usage

A few examples using the FACTDOUBLE function.

FACTDOUBLE(5)   // Returns 15  → 5 * 3 * 1  
FACTDOUBLE(6)   // Returns 48  → 6 * 4 * 2  
FACTDOUBLE(0)   // Returns 1   → double factorial of 0 is 1  
FACTDOUBLE(1)   // Returns 1   → double factorial of 1 is 1  
FACTDOUBLE(TRUE)  // Returns 1 → TRUE is treated as 1  
FACTDOUBLE(FALSE) // Returns 1 → FALSE is treated as 0, returns 1  
FACTDOUBLE(-3)  // Returns #NUM! → Negative numbers not supported

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Number",
        "Double Factorial",
        "Result"
    ],
    [
        5,
        "=FACTDOUBLE(A2)",
        15
    ],
    [
        6,
        "=FACTDOUBLE(A3)",
        48
    ],
    [
        8,
        "=FACTDOUBLE(A4)",
        384
    ],
    [
        10,
        "=FACTDOUBLE(A5)",
        3840
    ]
]
  }]
});
</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('OGFjYzBkMWZjN2I2NWYyMjc4NTMyMzNlMjE4Zjc4OTlkODQ0MjgxOGI0NWUyYjFhMjZjZDg4MjRhNWI4ODJiYTlhNThiNDcwZjNjNzBiMjc1YTcyOGEzNTMzNDkyODk3ZTEzZGM0MDljMDgwYmQ1MDcxZmRmMWQxN2Q0MmM3ZDAsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNVEE1TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Number",
        "Double Factorial",
        "Result"
    ],
    [
        5,
        "=FACTDOUBLE(A2)",
        15
    ],
    [
        6,
        "=FACTDOUBLE(A3)",
        48
    ],
    [
        8,
        "=FACTDOUBLE(A4)",
        384
    ],
    [
        10,
        "=FACTDOUBLE(A5)",
        3840
    ]
];

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

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Number",
        "Double Factorial",
        "Result"
    ],
    [
        5,
        "=FACTDOUBLE(A2)",
        15
    ],
    [
        6,
        "=FACTDOUBLE(A3)",
        48
    ],
    [
        8,
        "=FACTDOUBLE(A4)",
        384
    ],
    [
        10,
        "=FACTDOUBLE(A5)",
        3840
    ]
]

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

// 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: [
    [
        "Number",
        "Double Factorial",
        "Result"
    ],
    [
        5,
        "=FACTDOUBLE(A2)",
        15
    ],
    [
        6,
        "=FACTDOUBLE(A3)",
        48
    ],
    [
        8,
        "=FACTDOUBLE(A4)",
        384
    ],
    [
        10,
        "=FACTDOUBLE(A5)",
        3840
    ]
]
            }]
        });
    }
}

Edit this page on GitHub