Oct 27 2020 04:13 AM
($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.
Oct 27 2020 05:13 AM
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.
Oct 27 2020 05:47 AM
@Hans Vogelaar Thanks for quick help. Really appreciated.