Oct 02 2022 08:48 AM
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?
Oct 02 2022 09:16 AM
SolutionThis 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
Oct 02 2022 09:16 AM
SolutionThis 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