Problem with quotient function

Copper Contributor

($B6-SUMPRODUCT($C$4:E$4,$C6:E6)),F$4))= .1

F$4 = .1

I have above formulas whose values are .1  

When i'm putting these formula in quotient function =quotient(($B6-SUMPRODUCT($C$4:E$4,$C6:E6)),F$4)),F$4) I'm receiving zero but i should receive 1. 

Attaching the excel file where this formula is worked out in cell number F6. 

Any help on why am i getting 0 instead of 1 would be really appreciated. 

 

 

2 Replies

@udaykanttt 

It's a matter of rounding. In D5:

=QUOTIENT(ROUND($B5-SUMPRODUCT($C$4:C$4,$C5:C5),1),D$4)

Fill to the right to column F, then fill down to row 9 (or vice versa).

By the way, the formula in C5 can be

=QUOTIENT($B5,C$4)

for consistency.

@Hans Vogelaar Thanks for quick help. Really appreciated.