excelIF函数的嵌套使用方法和运用答:此题可以使用使用IF和VLOOKUP两种方法查找。第一,IF函数使用IF函数,需要进行7层嵌套才能完成。其中j列是辅助列,公式为:=IF(B33<=100,"1级",IF(B33<=200,"2级",IF(B33<=300,"3级",IF(B33<=400,"4级",IF(B33<=500,"5级",IF(B33<=600,"6级",IF(B33<=700,"7级","8级")))...
if函数怎么和vlookup函数嵌套使用?答:公式:=IF(VLOOKUP(B3,全员一览表!B:AD,25,0)=0,"",VLOOKUP(B3,全员一览表!B:AD,25,0))=IF(COUNTIF(key!B:B,H14)>0,"是","")=IF(COUNTIF(key!B:B,H14)=0,"","是")=IF(COUNTIF(key!B:B,H14),"是","")