用excel怎么把运费分摊到每个商品如何将运费分摊到各商品上去答:一、excel怎么分摊费用 =IF(ROW()>INT(($D$2-$C$2)/30)+1,"",$B$2/INT(($D$2-$C$2)/30)) =IF(ROW()>INT(($D$2-$C$2)/30)+1,"",IF(ROW()=2,YEAR(C2),IF(L1=12,K1+1,K1))) =IF(ROW()>INT(($D$2-$C$2)/30)+1,"",SUBSTITUTE(MOD(IF(ROW()=2,...
excel怎么分摊费用?答:=IF(ROW()>INT(($D$2-$C$2)/30)+1,"",$B$2/INT(($D$2-$C$2)/30))=IF(ROW()>INT(($D$2-$C$2)/30)+1,"",IF(ROW()=2,YEAR(C2),IF(L1=12,K1+1,K1)))=IF(ROW()>INT(($D$2-$C$2)/30)+1,"",SUBSTITUTE(MOD(IF(ROW()=2,MONTH(C2),L1+1),12),0,...