Excel的IF函数里如何套用其他表格数据（excel函数if如何套用2个以上条件）

直接把字符"√"替换为前者等于符号后的公式，即：=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))