IF函数公式,4个条件,4个结果,求解答:输入 =IF(Q7="处理","已完成",IF(Q7="审批","试验中",IF(R7="","未送货",IF(AND(R7="A接收",Q7=""),"未送试","")))详见附图示例
IF函数 两个条件 多个结果答:=IF(AND(C536="男",I536="男"),"父子",IF(AND(C536="男",I536="女"),"父女",IF(AND(C536="女",I536="男"),"母子",IF(AND(C536="女",I536="女"),"母女","")))
excel的if函数问题,如何同时满足5个条件答:=IF(F4="初中",5,IF(OR(F4={"中专","中技","高中"}),10,IF(F4="大专",15,IF(OR(F4={"大本","本科"}),20,25)))