‘=IF(A1=进口啡,石面,IF(A1=雨淋啡,石面,IF(A1=琥珀玉,石面,IF(A1=晚霞红,石面,IF(A1=
来源:学生作业帮 编辑:搜狗做题网作业帮 分类:综合作业 时间:2024/08/08 11:04:08
‘=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=](/uploads/image/z/4216802-50-2.jpg?t=%E2%80%98%3DIF%28A1%3D%E8%BF%9B%E5%8F%A3%E5%95%A1%2C%E7%9F%B3%E9%9D%A2%2CIF%28A1%3D%E9%9B%A8%E6%B7%8B%E5%95%A1%2C%E7%9F%B3%E9%9D%A2%2CIF%28A1%3D%E7%90%A5%E7%8F%80%E7%8E%89%2C%E7%9F%B3%E9%9D%A2%2CIF%28A1%3D%E6%99%9A%E9%9C%9E%E7%BA%A2%2C%E7%9F%B3%E9%9D%A2%2CIF%28A1%3D)
=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)