excel中，四个单元格有数字，则另一个单元格显示中文？

关键字：excel 更新时间：2019-03-21 20:14:15 178次访问

excel工作表中，四个单元格或其中任间数量的单元格中有数字，如何显示不同的文字？

=IF(COUNT(A2:D2)=4,"四边",COUNTIF(A2:B2)&"长"&COUNT(C2:D2)&"短")

e2=if(sum(a2:d2)=4,"四边",if((sum(a2:b2)=2)*(sum(c2:d2)=0),"两长",if((sum(a2:b2)=0)*(sum(c2:d2)=2),"两短",if((sum(a2:b2)=2)*(sum(c2:d2)=1),"两长一短",if((sum(a2:b2)=1)*(sum(c2:d2)=2),"一长两短",if((sum(a2:b2)=1)*(sum(c2:d2)=1),"一长一短",""))))))

然后下拉

=IF(COUNT(A2:D2)=4,"四边",COUNTIF(A2:B2)&"长"&COUNT(C2:D2)&"短"！

相关标签：excel