How to use the MOD function and QUOTIENT function in Excel
Multiplying addition and subtraction is the most familiar and simple calculation when we process data in Excel. In addition to these simple calculation types, there are more advanced ways to perform, for example, the calculation of the user can calculate the division function for the MOD balance and the integer division function for QUOTIENT in Excel. So, besides manually dividing, users can use more Excel functions to calculate more advanced calculations. The following article will guide readers to use the trade function in Excel.
- How to use the kernel function (PRODUCT function) in Excel
- How to use Lookup function in Excel
- How to combine Sumif and Vlookup functions in Excel
- Calculate the total value of the filtered list in Excel
1. Characteristics in Excel manually
We have the following table with trade calculation in Excel.
In cell D2 enter the calculation result, enter the formula = B2 / C2 and press Enter to get the result.
As a result, we get the calculation column calculated as shown below. In case the user wants to round the number, they can use the Round function in the article How to use the Round function in Excel or Excel Rounding Methods.
2. MOD function divides the balance
Syntax for MOD = (number, divisor) functions . In that number is the number to be divided to find the balance and divisior is the divisor. All 2 arguments in the MOD function are required.
If the result is the same as the divisor, do not care about the sign of the divisor. If the divisor is 0, the MOD function returns the error value. The MOD function returns 0 meaning that division calculation has no remainder.
For the above data table in the box to enter the first balance, the user enters the formula = MOD (B2, C2) and then press Enter.
As a result we will get the balance of the calculation 15/4 = 3. Drag the results of the first cell to the results for the remaining cells.
3. QUOTIENT function shares Excel integer
Syntax for function QUOTIENT = (numerator, denominator) . In which numerator is a divided number and denominator is a divisor. These two numbers are required in the formula. If one of the two arguments is not a number, the function QUOTIENT will return the error value.
In the first result box for the function QUOTIENT, we enter the formula = QUOTIENT (B2, C2) and press Enter.
When the first result is obtained, the user pulls down the remaining cells to show the results. The function only takes the trade value as an integer.
So, in Excel, there are many different ways of calculation, either manually or based on the above two functions. Depending on the requirements of the Excel exercise, we choose the appropriate calculation method.
I wish you all success!
You should read it
- How to use the SUM function to calculate totals in Excel
- Basic Excel functions that anyone must know
- How to fix the SUM function doesn't add up in Excel
- How to use Hlookup function on Excel
- How to use the LEN function in Excel
- MS Excel 2007 - Lesson 6: Calculation in Excel
- How to use MID functions to get strings in Excel
- How to use Excel's VALUE function
May be interested
- How to fix the insertion block in Excelinserting shape shapes into excel is very simple. so how to fix the inserted shapes into excel?
- How to make PowerPoint for beginnerscreating powerpoint slides for making reports, presentations or lectures is very simple.
- How to underline the broken word on Wordinstead of the underlined style under regular text, users can underline the broken character on word.
- How to center the cell in the PowerPoint tablethe fact that the text is in the middle of the box on powerpoint makes the presentation much more professional.
- How to insert a countdown timer in PowerPointwhen adding a countdown timer on a powerpoint slide will make presentations more unique.
- 7 free Excel templates to help manage the budgetthe focus of every financial plan lies in managing money or budget. whether you have a large amount of money on hand or just live on a monthly salary, you need a clear spending plan to know what your money will be used for.