Products

MULTIPLY function

PRO

The MULTIPLY function in Jspreadsheet Formulas Pro is a simple tool that calculates the product of exactly two numbers. It's like doing a multiplication operation. You simply input the two numbers you wish to multiply as arguments into the function, and it will provide you with the result. This function is a great tool for performing calculations quickly and accurately in your spreadsheet.

Documentation

Returns the product of two numbers.

Category

Math and trigonometry

Syntax

MULTIPLY(factor1, factor2)

Parameter Description
factor1 First number to multiply.
factor2 Second number to multiply.

Behavior

The MULTIPLY function is used to multiply two or more numbers. Here's how it behaves in different scenarios:

  • Empty cells: If one of the cells referenced in the function is empty, the MULTIPLY function treats it as zero.
  • Text: If the function is used on cells that contain text, it will return an error, since multiplication is not applicable to text.
  • Booleans: Boolean values are treated as numbers. Therefore, TRUE is regarded as 1 and FALSE as 0 when used in the MULTIPLY function.
  • Errors: If one of the cells referenced in the function contains an error, the MULTIPLY function will also return that error.

Common Errors

Error Description
#VALUE! This error occurs if one or more of the arguments are text that cannot be converted into numbers.
#REF! This error is displayed when a cell reference is not valid. This can occur if a cell that is being referenced has been deleted.

Best practices

  • Always ensure that the cells you're referencing in your MULTIPLY function contain numbers. If there's a chance they might contain text, use error checking functions to handle these cases.
  • Be aware that empty cells will be treated as zero. If you don't want this behavior, you should add checks to exclude empty cells from the multiplication.
  • If you're working with boolean values, remember that they will be treated as 1 (for TRUE) and 0 (for FALSE).
  • Check your function for correct spelling and syntax to avoid #NAME? errors.

Usage

A few examples using the MULTIPLY function.

MULTIPLY(5, 10) returns 50  
MULTIPLY(10, -1) returns -10  

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

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Product A",
        25,
        12,
        "=MULTIPLY(B1,C1)"
    ],
    [
        "Product B",
        8,
        15,
        "=MULTIPLY(B2,C2)"
    ],
    [
        "Product C",
        30,
        7,
        "=MULTIPLY(B3,C3)"
    ],
    [
        "Product D",
        18,
        9,
        "=MULTIPLY(B4,C4)"
    ]
]
  }]
});
</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('MzI2NDU0MDk3MzlmNWNhMzFjMDlhNWI5ZmUzYzBmMDkxN2M4YTlmM2U1OWI0NmU1MzZmZGMxZDA5ZjMzMWE1NWZlZDc0Y2QyZGY2OTZiMTVjMDJmMDBkZmFjYzkzMjE1NWMzZmEzM2VlODU0OTI3YWU3NWVjZTYxOTJmMTY1YTcsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOekF3TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Product A",
        25,
        12,
        "=MULTIPLY(B1,C1)"
    ],
    [
        "Product B",
        8,
        15,
        "=MULTIPLY(B2,C2)"
    ],
    [
        "Product C",
        30,
        7,
        "=MULTIPLY(B3,C3)"
    ],
    [
        "Product D",
        18,
        9,
        "=MULTIPLY(B4,C4)"
    ]
];

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

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Product A",
        25,
        12,
        "=MULTIPLY(B1,C1)"
    ],
    [
        "Product B",
        8,
        15,
        "=MULTIPLY(B2,C2)"
    ],
    [
        "Product C",
        30,
        7,
        "=MULTIPLY(B3,C3)"
    ],
    [
        "Product D",
        18,
        9,
        "=MULTIPLY(B4,C4)"
    ]
]

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

// 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: [
    [
        "Product A",
        25,
        12,
        "=MULTIPLY(B1,C1)"
    ],
    [
        "Product B",
        8,
        15,
        "=MULTIPLY(B2,C2)"
    ],
    [
        "Product C",
        30,
        7,
        "=MULTIPLY(B3,C3)"
    ],
    [
        "Product D",
        18,
        9,
        "=MULTIPLY(B4,C4)"
    ]
]
            }]
        });
    }
}