EXCEL数据比对结果,相把#N/A显示成空或0答:=IF(ISERROR(VLOOKUP(B10,总表!$A$1:$C$996,3,0)),"",VLOOKUP(B10,总表!$A$1:$C$996,3,0))07及以上版 =IFERROR(VLOOKUP(B10,总表!$A$1:$C$996,3,0),"")
关于excel表格函数的问题?答:整个公式用VLOOKUP设置公式:=IFERROR(VLOOKUP(A9,{"水稻",485;"玉米",415;"小麦",235;"大麦",245;"干蚕豆",165;"干豌豆",135;"大豆",165;"杂豆",185;"油菜籽",140;"花生米",210;"葵花籽",110;"甘蔗",3650;"白菜",2850;"苦菜",2150;"萝卜",3650;"青椒",1100;"莲花白",2850;"...
excel if公式求解答:解答1:=IF(AND(A2=$D$1,NOT(IFERROR(FIND("缝",C2),FALSE))),B2,"")解答2:=IF(AND(A2=$D$1,IFERROR(FIND("缝",C2),FALSE)),B2,"")