excel - 一起使用 IF AND OR ..？

Question

我正在尝试过滤具有多行不需要的电子表格，除非符合某些条件。问题是我不断收到#VALUE!错误。具体来说，这就是我想要的

IF DHR!E10="Payment Processed"AND DHR!F10="completed"OR IF DHR!E10="subscription payment completed"AND DHR!F10="completed"THEN DHR!A10 否则为 ""。

然后 DHR!E10 必须等于“付款已处理”或“订阅付款已完成”
DHR!F10 必须始终等于“已完成”
这就是我所做的:

=IF(OR(IF(AND(DHR!E10="Payment Processed",DHR!F10="completed"),DHR!A10,"")=DHR!A10,(IF(AND(DHR!E10="subscription payment completed",DHR!F10="completed"),DHR!A10,"")))=DHR!A10,DHR!A10,"")

预先感谢您的任何帮助。

Answer 1

这将起作用，不:
=IF(AND(DHR!F10="Completed",OR(DHR!E10="Subscription Payment Complete",DHR!E10="Payment Processed")),DHR!A10,"")