Forum Discussion
Solved
Quotient Formula for when the Numerator is smaller than the Denominator
The image below is an example of this quotient issue. https://imgur.com/a/xgpHQyp Whenever the numerator is smaller than the denominator, the result will always be zero. Why is this the case? Why ...
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