EXCEL 表格公式

推荐回答

=IF(ROW()=2,G2,IF(SUMIFS(C$1:C1,B$1:B1,B1)<SUMIFS(H:H,G:G,B1),B1,LOOKUP(1,0/(G$1:G$100=B1),G$2:G$101)))

=IF(SUMIFS(C$1:C1,B$1:B1,B2)+IF(B2="草莓",20,IF(B2="香蕉",30,IF(B2="苹果",40)))<SUMIFS(H:H,G:G,B2),IF(B2="草莓",20,IF(B2="香蕉",30,IF(B2="苹果",40))),SUMIFS(H:H,G:G,B2)-SUMIFS(C$1:C1,B$1:B1,B2))

=SUMIF($B$2:$B$7,G2,$C$2:$C$7)