Forum Discussion
Solved
Quotient Formula for when the Numerator is smaller than the Denominator
The image below is an example of this quotient issue.
Whenever the numerator is smaller than the denominator, the result will always be zero. Why is this the case? Why can't Excel provide the actual answer? Do I really have to manually use a calculator and find the result? What if I had massive amounts of data, and I wanted to find the decimal values?
This is the intended result. The QUOTIENT function performs integer division, not standard division.
For example, =QUOTIENT(23, 4) returns 5 because 4 goes 5 times into 23 (with a remainder of 3: 23 = 5 * 4 + 3)
If you want standard division, use the / operator:
=A115/B115
This is the intended result. The QUOTIENT function performs integer division, not standard division.
For example, =QUOTIENT(23, 4) returns 5 because 4 goes 5 times into 23 (with a remainder of 3: 23 = 5 * 4 + 3)
If you want standard division, use the / operator:
=A115/B115
