Problem with quotient function

%3CLINGO-SUB%20id%3D%22lingo-sub-1822386%22%20slang%3D%22en-US%22%3EProblem%20with%20quotient%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822386%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3CSPAN%3E(%24B6%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3ESUMPRODUCT(%3CSPAN%3E%24C%244%3AE%244%3C%2FSPAN%3E%2C%3CSPAN%3E%24C6%3AE6%3C%2FSPAN%3E))%2C%3CSPAN%3EF%244%3C%2FSPAN%3E))%3D%20.1%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EF%244%20%3D%20.1%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EI%20have%20above%20formulas%20whose%20values%20are%20.1%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EWhen%20i'm%20putting%20these%20formula%20in%20quotient%20function%20%3Dquotient(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3CSPAN%3E(%24B6%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3ESUMPRODUCT(%3CSPAN%3E%24C%244%3AE%244%3C%2FSPAN%3E%2C%3CSPAN%3E%24C6%3AE6%3C%2FSPAN%3E))%2C%3CSPAN%3EF%244%3C%2FSPAN%3E))%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EF%244)%20I'm%20receiving%20zero%20but%20i%20should%20receive%201.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EAttaching%20the%20excel%20file%20where%20this%20formula%20is%20worked%20out%20in%20cell%20number%20F6.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EAny%20help%20on%20why%20am%20i%20getting%200%20instead%20of%201%20would%20be%20really%20appreciated.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1822386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822513%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20quotient%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F847305%22%20target%3D%22_blank%22%3E%40udaykanttt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20a%20matter%20of%20rounding.%20In%20D5%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DQUOTIENT(ROUND(%24B5-SUMPRODUCT(%24C%244%3AC%244%2C%24C5%3AC5)%2C1)%2CD%244)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EFill%20to%20the%20right%20to%20column%20F%2C%20then%20fill%20down%20to%20row%209%20(or%20vice%20versa).%3C%2FP%3E%0A%3CP%3EBy%20the%20way%2C%20the%20formula%20in%20C5%20can%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DQUOTIENT(%24B5%2CC%244)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Efor%20consistency.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@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.

Highlighted

@Hans Vogelaar Thanks for quick help. Really appreciated.