Forum Discussion

Remya Ramakrishnan's avatar
Remya Ramakrishnan
Copper Contributor
Feb 09, 2018
Solved

Divide a quantity as whole number among multiple cells

Hello, Any suggestion for an excel formula to derive A2, B2, C2, D2 values.   Eg: Category Income A B C D Sal1 11 3 3 3 2   if we divide 11 among 4 c...
excel
Formulas and Functions
  • Willy Lau's avatar
    Willy Lau
    Feb 09, 2018
    =MIN(IF(COLUMN()=3,$B2,$B2-SUM($C2:OFFSET(C2,0,-1))), ROUNDUP($B2/(SUMPRODUCT(NOT($1:$1=0)*1)-2),0))
Willy Lau's avatar
Willy Lau
Steel Contributor
Feb 09, 2018
=MIN(IF(COLUMN()=3,$B2,$B2-SUM($C2:OFFSET(C2,0,-1))), ROUNDUP($B2/(SUMPRODUCT(NOT($1:$1=0)*1)-2),0))
waqar_804's avatar
waqar_804
Copper Contributor
Feb 10, 2020
($1:$1=0)

i didnt't understand this thing could you please explain it.Willy Lau 

Resources