Google表格(如果另有此规定)或 [英] Google Sheets IF THIS AND ELSE OR

问题描述

我在尝试在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表格(如果另有此规定)或的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！