本文介绍了Google表格(如果另有此规定)或的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在尝试在Google表格中完成以下操作时遇到了一些问题.我想发生的事情是:
I'm having some issues trying to accomplish the below in a google sheet.What I'd like to have happened is:
IF Cell O1 has a value of "Yes" AND Cell E1 is <= 25,000
Cell P1 = "DEFM-HW-A"
OR Cell O1 has a value of "Yes" AND Cell E1 is > 25,000
Cell P1 = "DEFM-HW-B"
OR IF O1 = "No"
Cell P1 = "No"
推荐答案
在P1中使用它:
=IF(O1="Yes",IF(E1<=25000,"DEFM-HW-A","DEFM-HW-B"),"No")
这篇关于Google表格(如果另有此规定)或的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！