Forum Discussion

udaykanttt's avatar
udaykanttt
Copper Contributor
Oct 27, 2020

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)),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. 

 

 

excel
Excel on Mac
Formulas and Functions
office 365

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 27, 2020

    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.

Resources