The Function of Dividing Remainder and Dividing by Integer

This article provides a clear overview of The Function of Dividing Remainder and Dividing by Integer, with the main facts, useful context, and practical details organized for easy reading.

There are two different division functions:

- MOD function: divide the remainder.

- QUOTIENT function: divide by integer.

this guide describes the syntax and usage of two division functions: MOD and QUOTIENT.

MOD Function

Description

The MOD function is a division function that returns the remainder of the division.

Syntax

MOD (number, divisor)

Arguments

- number: the number you may need to find the balance (the number to be divided), required.

- divisor: divisor , required.

Note

- Results with the sign of the divisor, regardless of the sign of the dividend.

- If the divisor is 0, then the MOD function returns the error value.

For Example

Given the following data sheet:

Requirements: Calculate the balance when taking the number in Number divided by the Divisor.

Applying the MOD function formula to the first cell: = MOD (B5, C5) we get the following:

You do with the next row and follow the results of the MOD function always the same sign with the divisor.

QUOTIENT Function

Description

The QUOTIENT function is a division function that returns the integral of a division.

Syntax

QUOTIENT (numerator, denominator)

Arguments

- Numerator: is a divisible and required number.

- denominator: a divisor, required.

If either numerator or denominator is not a number, QUOTIENT returns the error value.

For Example

Give the data table as follows:

Requirement: Use the QUOTIENT function to get the integer part when taking Numerator numbers and dividing by Denominator numbers.

Apply the QUOTIENT function formula to cell D5: = QUOTIENT (B5, C5) .

Similar to other data, you will get the following results: