Question

请教各位大神们一个excel问题

当I2、J2、K2、L2出现1或无数字时，G2则显示不同文字。请问各位大神如何实现这一要求? 具体要求请看图片。

Answer 1

G2公式如下：

=HLOOKUP(J2+K2&L2+M2,{"00","01","02","10","11","12","20","21","22";0,"一短","两短","一长","一长一短","一长两短","两长","两长一短","四边"},2,)

Answer 2

为了避免使用If函数时候公式太长，我加了两列辅助列。公式分别是：

H30=IF(SUM(C30:D30)=1,"一长",IF(SUM(C30:D30)=2,"两长",""))

I30=IF(SUM(E30:F30)=1,"一短",IF(SUM(E30:F30)=2,"两短",""))

然后封边要求的公式为A30=IF(SUM(C30:F30)=4,"四边",H30&I30)

Answer 3

在G2单元格输入公式IF(SUM(J2:K2),SUM(J2:K2)&"长","")&IF(SUM(L2:M2),SUM(L2:M2)&"短","")

下拉至G8单元格

G9单元格输入公式IF(SUM(J9:M9),SUM(J9:M9)&"边","")

Answer 4

在G2中输入 =IF(J2+K2=0,"",IF(J2+K2=1,"一长","两长"))&IF(L2+M2=0,"",IF(L2+M2=1,"一短","两短")) 下拉就可以了

Answer 5

很简单的，G2＝sum(J2:K2)&"长"&sum(L2:M2)&"短"，公式下拉下拉。只是这样显示的数学数字，理解上应试没有问题吧。