SOLVED

Quotient Formula for when the Numerator is smaller than the Denominator

Copper Contributor

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 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 (Copper Contributor)
Solution

@MuradValiev 

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

1 best response

Accepted Solutions
best response confirmed by MuradValiev (Copper Contributor)
Solution

@MuradValiev 

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

View solution in original post