excel中if函数的问题,如何在四个单元格全都满足条件的情况下,在另一...答:=IF(and(B21=1 ,C21=0 ,D21=2 ,E21=2 ,F21=3),INDEX(H15:K27,1,2),"")
Excel的IF函数里如何套用其他表格数据?答:直接把字符"√"替换为前者等于符号后的公式,即:=IF(J9>35,INDEX({"A","B","C"},3*RAND()+1),IF(J9=35,INDEX({"A","B","C"},3*RAND()+1),IF(J9<35,"")))公式可简化为:=IF(J9<35,"",INDEX({"A","B","C"},3*RAND()+1))...