Discussion:
如何完成下列計算?
(时间太久无法回复)
Hoxmaerd
2007-10-07 22:23:01 UTC
Permalink
A1=3, A2=5, A3=8, A4=11;
B2=N.

當 B2=2 時，計算A1~A4中最大的前二個數的和為19;
當 B2=3 時，計算A1~A4中最大的前三個數的和為22;
在C3中顯現計算結果
ªá¥Ò¯Î
2007-10-08 11:03:21 UTC
Permalink
A1~A4€€³Ì€jªº«e€T­ÓŒÆªº©M¬°11+8+5=24 ?
c3=IF(B2=2,SUM(LARGE(A1:A4,{1,2})),SUM(LARGE(A1:A4,{1,2,3})))
Post by Hoxmaerd
A1=3, A2=5, A3=8, A4=11;
B2=N.
·í B2=2 ®É¡A­pºâA1~A4€€³Ì€jªº«e€G­ÓŒÆªº©M¬°19;
·í B2=3 ®É¡A­pºâA1~A4€€³Ì€jªº«e€T­ÓŒÆªº©M¬°22;
ŠbC3€€Åã²{­pºâµ²ªG
ªá¥Ò¯Î
2007-10-08 12:13:06 UTC
Permalink
c3=if(b2=0,"",IF(B2=2,SUM(LARGE(A1:A4,{1,2})),if(b2=3,SUM(LARGE(A1:A4,{1,2,3})),"")))
Post by ªá¥Ò¯Î
A1~A4€€³Ì€jªº«e€T­ÓŒÆªº©M¬°11+8+5=24 ?
c3=IF(B2=2,SUM(LARGE(A1:A4,{1,2})),SUM(LARGE(A1:A4,{1,2,3})))
Post by Hoxmaerd
A1=3, A2=5, A3=8, A4=11;
B2=N.
·í B2=2 ®É¡A­pºâA1~A4€€³Ì€jªº«e€G­ÓŒÆªº©M¬°19;
·í B2=3 ®É¡A­pºâA1~A4€€³Ì€jªº«e€T­ÓŒÆªº©M¬°22;
ŠbC3€€Åã²{­pºâµ²ªG
Loading...