四舍五入後差距 加減處 (10528)

C3:C9=ROUND(B$1/SUM(B$3:B$9)*B3,2)

D3:D9=B$1/SUM(B$3:B$9)*B3

E3:E9=C3-D3

F3:F9{=IF(SUM(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,2))>B$1,ROUND(B$1/SUM(B$3:B$9)*B3,2)-IF(ROW(A1)=MATCH(MAX(MMULT(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,{2,8}),{1;-1})),MMULT(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,{2,8}),{1;-1}),),SUM(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,2))-B$1,),ROUND(B$1/SUM(B$3:B$9)*B3,2)+IF(ROW(A1)=MATCH(MIN(MMULT(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,{2,8}),{1;-1})),MMULT(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,{2,8}),{1;-1}),),B$1-SUM(ROUND(B$1/SUM(B$3:B$9)*B$3:B$9,2)),))

差距加至最後 C3:C9=IF(A4="合计",100-SUM(C$2:C2),ROUND(B$1/SUM(B$3:B$9)*B3,2))