大佬们，这里有if函数的问题（求救贴）

=IF(AND(E5="重要"，F5=“紧急”),"A",IF(AND(E5="重要",F5="不紧急","B",IF(AND(E5="不重要",F5="紧急","C","D")))))
这个不能实现是因为我嵌套的太离谱了吗？

=IF(AND(E5="重要",F5="紧急"),"A",IF(AND(E5="重要",F5="不紧急"),"B",IF(AND(E5="不重要",F5="紧急"),"C",IF(AND(E5="不重要",F5="不紧急"),"D","E"))))

不感兴趣

开通SVIP免广告

=IF(AND(E5="重要",F5="紧急"),"a",IF(AND(E5="重要",F5="不紧急"),"b",IF(AND(E5="不重要",F5="紧急"),"c","d")))

=LOOKUP(CONCAT(FIND({"重要","紧急"},E5:F5))*1,{11,12,21,22},{"A","C","B","D"})

下载贴吧APP
看高清直播、视频！

分享到: