QUOTIENT function
PRO
BASIC
The QUOTIENT
function in Jspreadsheet Formulas Pro is used to return the whole number result of a division operation, disregarding any remainder. This function is useful when you only need the integer part of a division. For example, if you divide 10 by 3, the QUOTIENT
function will return 3, ignoring the remainder. It's efficient when you need to determine how many times a number can be evenly divided.
Documentation
Returns the integer portion of a division operation. It discards the remainder and returns only the whole number that divides evenly into the dividend.
Category
Math and trigonometry
Syntax
QUOTIENT(numerator, denominator)
Parameter | Description |
---|---|
numerator |
The number to be divided. |
denominator |
The number by which to divide the numerator. |
Behavior
The QUOTIENT
function is used to return the integer portion of a division operation. Here's how it handles different types of inputs:
- Numbers: The function works flawlessly with numeric inputs. For example, QUOTIENT(10, 2) would return 5.
- Empty Cells: If the denominator is empty, the function returns a #DIV/0! error. If the numerator is empty, the function is treated as 0.
- Text: If either of the arguments is a text, the function would return a
#VALUE!
error. - Booleans: The function treats
TRUE
as 1 andFALSE
as 0. For example, QUOTIENT(TRUE, 2) would return 0. - Errors: If either of the arguments is an error, the function would propagate that error. For instance, if the denominator is
#DIV/0!
, the function would also return#DIV/0!
.
Common Errors
Error | Description |
---|---|
#DIV/0! | This error occurs when the denominator is zero or an empty cell. |
#VALUE! | This error occurs when either the numerator or the denominator is non-numeric. |
Best practices
- Always ensure that the denominator is not zero or an empty cell to avoid the
#DIV/0!
error.- Avoid using non-numeric values as arguments to the QUOTIENT function to prevent the
#VALUE!
error.- Be mindful of the fact that the QUOTIENT function only returns the integer portion of the result. If you need the remainder or the exact result of the division, consider using other functions such as MOD or DIVIDE.
- Handle booleans carefully as they are treated as 0 and 1. If you have boolean values in your data, it might be safer to convert them to explicit numeric values before using them in the QUOTIENT function.
Usage
A few examples using the QUOTIENT function.
QUOTIENT(10,3) returns 3 because the integer part of 10 ÷ 3 is 3
QUOTIENT(1000,7) returns 142 because 1000 ÷ 7 = 142 with a remainder of 6
QUOTIENT(A1,B1) returns the integer portion of dividing the value in A1 by the value in B1
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('M2Q0MDAxZDAzNzRlNWRlNTI1ZjRkNjAwNzBjY2EzOGZmMjljMDg3Mjk4N2ZlZjQ4ZWIxZTIwMmQ3ZDAyOTAwZTQ3YzY1NzgzNTBhOWViYWI2MmRkNzNlYmFiMTlmZDdkY2UzNjJiNDY0ZGMxNTY4MDhjMmVhOTNjNGIzYmE1N2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek16TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: [
[
"Items",
"Per Box",
"Full Boxes"
],
[
47,
12,
"=QUOTIENT(A2,B2)"
],
[
128,
15,
"=QUOTIENT(A3,B3)"
],
[
95,
8,
"=QUOTIENT(A4,B4)"
],
[
203,
25,
"=QUOTIENT(A5,B5)"
]
]
}]
});
</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('M2Q0MDAxZDAzNzRlNWRlNTI1ZjRkNjAwNzBjY2EzOGZmMjljMDg3Mjk4N2ZlZjQ4ZWIxZTIwMmQ3ZDAyOTAwZTQ3YzY1NzgzNTBhOWViYWI2MmRkNzNlYmFiMTlmZDdkY2UzNjJiNDY0ZGMxNTY4MDhjMmVhOTNjNGIzYmE1N2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek16TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default function App() {
// Spreadsheet array of worksheets
const spreadsheet = useRef();
// Worksheet data
const data = [
[
"Items",
"Per Box",
"Full Boxes"
],
[
47,
12,
"=QUOTIENT(A2,B2)"
],
[
128,
15,
"=QUOTIENT(A3,B3)"
],
[
95,
8,
"=QUOTIENT(A4,B4)"
],
[
203,
25,
"=QUOTIENT(A5,B5)"
]
];
// 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('M2Q0MDAxZDAzNzRlNWRlNTI1ZjRkNjAwNzBjY2EzOGZmMjljMDg3Mjk4N2ZlZjQ4ZWIxZTIwMmQ3ZDAyOTAwZTQ3YzY1NzgzNTBhOWViYWI2MmRkNzNlYmFiMTlmZDdkY2UzNjJiNDY0ZGMxNTY4MDhjMmVhOTNjNGIzYmE1N2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek16TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default {
components: {
Spreadsheet,
Worksheet,
},
data() {
// Worksheet data
const data = [
[
"Items",
"Per Box",
"Full Boxes"
],
[
47,
12,
"=QUOTIENT(A2,B2)"
],
[
128,
15,
"=QUOTIENT(A3,B3)"
],
[
95,
8,
"=QUOTIENT(A4,B4)"
],
[
203,
25,
"=QUOTIENT(A5,B5)"
]
]
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('M2Q0MDAxZDAzNzRlNWRlNTI1ZjRkNjAwNzBjY2EzOGZmMjljMDg3Mjk4N2ZlZjQ4ZWIxZTIwMmQ3ZDAyOTAwZTQ3YzY1NzgzNTBhOWViYWI2MmRkNzNlYmFiMTlmZDdkY2UzNjJiNDY0ZGMxNTY4MDhjMmVhOTNjNGIzYmE1N2IsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek16TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// 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: [
[
"Items",
"Per Box",
"Full Boxes"
],
[
47,
12,
"=QUOTIENT(A2,B2)"
],
[
128,
15,
"=QUOTIENT(A3,B3)"
],
[
95,
8,
"=QUOTIENT(A4,B4)"
],
[
203,
25,
"=QUOTIENT(A5,B5)"
]
]
}]
});
}
}