Quotient Formula for when the Numerator is smaller than the Denominator

New Contributor

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? 

1 Reply
best response confirmed by MuradValiev (New Contributor)


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: