excel多条件包含函数怎么写?答:源数据在A列,A1起。在B1输入 =IF(COUNT(FIND({"xx","yy"},A1)),"xx",IF(COUNT(FIND({"xx","yy","xx"},A1)),"USA",IF(COUNT(FIND("xx",A1)),"india","")))回车并向下填充。如下图:假设数据在A列,公式=IF(A1>100,a运算,IF(A1>1,b运算,c运算))。运算公式自己编写。
EXCEL中if函数多个条件包括日期、数值和文本,应该怎么写答:=IF(E3>=200,"是",IF(AND(D3<="4月11日",E3<200),"否",IF(AND(D3>"4月11日",E3<200,C3="在职"),"继续观察","否")))