Forum Discussion
Problem with quotient function
($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...
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.
HansVogelaar Thanks for quick help. Really appreciated.