谷歌定位片如果这一点，其他人或(Google Sheets IF THIS AND ELSE OR)

我有一些问题想要完成一个谷歌片的下方。 我想已经发生的是：

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"

Answer 1:

在P1使用此：

=IF(O1="Yes",IF(E1<=25000,"DEFM-HW-A","DEFM-HW-B"),"No")

文章来源: Google Sheets IF THIS AND ELSE OR