Combining IF AND and IF OR Statements

[Mira499]

Hi there,

I've been banging my head upon this for the past few hours and so I thought best to defer to the experts.

IF E3 = "Closed" OR "Rejected"

AND

S3 = "", T3>0, M3>0 (All 3 conditions must be met)

Here is the formula I have so far... I've not yet figured out how to include "Rejected"

=IF(OR(E3="Closed",AND(S3="",T3>0,M3>0)),"Pending Approval","Not Pending")

Any help would be greatly appreciated!

 

[lrobbo314]

How about this?

=IF(AND(OR(E3="Closed",E3="Rejected"),S3="",T3>0,M3>0),"Pending Approval","Not Pending")

 

[Mira499]

How about this?

=IF(AND(OR(E3="Closed",E3="Rejected"),S3="",T3>0,M3>0),"Pending Approval","Not Pending")

Works nicely... Thank you very much!

 

[lrobbo314]

No problem, thanks for the reply.