‘=IF(A1=进口啡,石面,IF(A1=雨淋啡,石面,IF(A1=琥珀玉,石面,IF(A1=晚霞红,石面,IF(A1=

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/19 00:16:16

‘=IF(A1=进口啡,石面,IF(A1=雨淋啡,石面,IF(A1=琥珀玉,石面,IF(A1=晚霞红,石面,IF(A1=波斯灰,石面,IF(A1=国产啡,石面,IF(A1=橙红皮深雕,石面IF(A1=红龙玉,石面""))))))）这个公式哪里错了?

=IF(A1=进口啡,"石面",IF(A1=雨淋啡,"石面",IF(A1=琥珀玉,"石面",IF(A1=晚霞红,"石面",IF(A1=波斯灰,"石面",IF(A1=国产啡,"石面",IF(A1=橙红皮深雕,"石面","石面")))))))
标点或括号有错.
上面公式,你试一下.
不知有何用处?结果都是“石面”.没有判断意义.

‘=IF(A1=进口啡,石面,IF(A1=雨淋啡,石面,IF(A1=琥珀玉,石面,IF(A1=晚霞红,石面,IF(A1= 公式=IF(A1 =IF(A1 =IF(COUNTA($A1:$E1)>=COLUMN(A1),INDEX($A1:$E1,SMALL(IF($A1:$ F1=IF($A1="","",IF($A1+COLUMN($A1)+5=COLUMN(),COLUMN()-COLUM =IF(SUM(A1:A5)>0,SUM(A1:A5) 英语翻译=IF($A1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小"," =IF(ISNUMBER(T(A1)),"数字","文本") [=IF(COUNTIF($B:$B,$A1)=0,"",VLOOKUP($A1,$B:$C,COLUMN(A1),)) =IF(COUNTIF(A$1:A1,A1)=1,COUNTIF(A:A,A1),"") IF(AND(MONTH(A1)>=9,DAY(A1)>=1),DATEDIF(A1,TODAY(),"y")-1,DA =IF(ROW(A1)>7,"",INDIRECT("sheet1!A"&ROW(A1)+COLUMN(A1)*7-7)