計(jì)算結(jié)果兩個(gè)公式保留整數(shù),另外一個(gè)保留兩位小數(shù)點(diǎn),在下面的公式怎么加入函數(shù)
AI29=IF(VLOOKUP(F29,$BB$2:$BD$197,3,0)="a",MAX($U$3,VLOOKUP(B29,$B$7:$C$18,2,0)),IF(VLOOKUP(F29,$BB$2:$BD$197,3,0)="b",SUMIF($B$7:$B$18,B29,$AD$7:$AD$18)+SUMIF($B$7:$B$18,B29,$AF$7:$AF$18),SUMPRODUCT(($B$7:$B$18=B29)*(($AD$7:$AD$18)+($AF$7:$AF$18))*($Y$7:$Y$18))*500))
IF(VLOOKUP(F29,$BB$2:$BD$197,3,0)="a",MAX($U$3,VLOOKUP(B29,$B$7:$C$18,2,0)),
SUMPRODUCT(($B$7:$B$18=B29)*(($AD$7:$AD$18)+($AF$7:$AF$18))*($Y$7:$Y$18))*500))
這兩個(gè)只保留整數(shù)
IF(VLOOKUP(F29,$BB$2:$BD$197,3,0)="b",SUMIF($B$7:$B$18,B29,$AD$7:$AD$18)+SUMIF($B$7:$B$18,B29,$AF$7:$AF$18),這個(gè)保留兩位小數(shù)點(diǎn),
怎么加入函數(shù)?