How To Divide In Excel Formula Using Quotient Excel Function

How to Divide using Excel Formulas?

Below are some examples through which you may learn how to use formulas to divide numbers in Excel and calculate percentages.

Example #1

We have data on class students who recently appeared in the annual exam. We have the name and total marks they wrote for the exam and the total marks they obtained in the exam.

We need to find out the percentage of these students.

Here we need to divide the achieved marks by total marks. The formula is:

Achieved Marks / Total Marks * 100

Here, we find out the percentage of the students.

Example #2

We have a cricket scorecard. The individual runs they scored and total boundaries they hit in their innings.

We need to find how many runs once they score a boundary.

We have divided the runs by boundary. The results are in decimals. Let us apply the Quotient in excelQuotient In ExcelThe QUOTIENT function in Excel returns only the integer quotient and ignores the remainder Quotient (Value 1/Value 2). For example, Quotient (16/6) = 2.read more to find out the result.

The QUOTIENT function requires two mandatory parameters: numerator and denominator.

Numerator: This is the number we are dividing.Denominator: From this number, we are dividing the numerator in excel.

The QUOTIENT function rounds down the values. However, it will not show the decimal values.

Conclusion: Sachin hits a boundary for every 14th run, Sehwag hits a boundary for every 9th run, etc.

Example #3

I have one unique problem here. One day I was busy with my analysis work, and one of the sales managers called and asked if I had an online client. I pitched him for $400,000 plus taxes, but he is asking me to include the tax in the $400,000 itself, i.eHe is requesting the product for $400,000 inclusive taxes.

We need tax percentage, multiplication rule, and division rule to find the base value.

We must apply the Excel formula below to divide what we have shown in the image.

Firstly, the inclusive value is multiplied by 100, and then it is divided by 100 + tax percentage. So, that would give us the base value.

To cross-check, we can take 18% of $338,983 and add a percentage value of $338,983. We should get $400,000 as of the overall value.

Sales managers can mention on the contract $338,983 + 18% tax.

We can also do this by using the QUOTIENT function. The below image is an illustration of the same.

How to Handle #DIV/0! Error in Excel Divide Formula?

In excel, when we are dividing, we get excel errorsExcel ErrorsErrors in excel are common and often occur at times of applying formulas. The list of nine most common excel errors are - #DIV/0, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!, #####, Circular Reference.read more as #DIV/0!. This section of the article will explain how to deal with those errors.

We have a five years budget vs. the actual number. So, we need to find out the variance percentages.

We must apply the Excel formula first to divide, as shown in the below image.

The problem here is we got an error in the last year, 2018. Since there are no budgeted numbers in 2018, we got #DIV/0! Error because we cannot divide any number by zero.

We can eliminate this error by using the IFERROR function in excelUsing The IFERROR Function In ExcelThe IFERROR function in Excel checks a formula (or a cell) for errors and returns a specified value in place of the error.read more.

The IFERROR function in Excel converts all the error values to zero.

Things to Remember

To divide in an Excel formula, we cannot divide any number by zero. If done, we will get an error as #DIV/0!.For the QUOTIENT function, both the arguments are mandatory.In case of an error, we must use the IFERROR functionUse The IFERROR FunctionThe IFERROR function in Excel is used to determine what to do when an error occurs before performing any function.read more to remove the error and replace it with any value according to our wish.

How to Divide using Excel Formulas?#

Example #1#

Example #2#

Example #3#

How to Handle #DIV/0! Error in Excel Divide Formula?#

Things to Remember#

Recommended Articles#