How to combine OR and AND when referring to same cell

Hi Experts,

please can you help me with this formula & what is the logic error in this

IF(OR(G2<>"",AND(G2<>"No",D2>8000)),E2,"") -- > Does not work when G2 is Null or G2 is NO


IF((OR(G2<>"No", G2<>"",AND(D5>8000))),F2,"") -->Does not work when G2 is Null or G2 is NO

I have attached the sample sheet. Your help would be appreciated.



Thanks a ton

Thank you @bebo021999
for the response.


This is what I want:
When Status(Column G) is NOT Blank OR NO, and Sales > 8000 then I want Result(Column E) to be displayed else Blank
I could say Status is YES but I have 8 states in my data file. So using NOT logic.
Is this possible ?

Thanks in Advance

Maybe

Formula:

Please Login or Register  to view this content.

Originally Posted by Fluff13

Maybe

Formula:

Please Login or Register  to view this content.

Thank you very much @Fluff13, This really works on my sample file as expected. I will try this on my data file tomorrow.
Please have a great day. Thank you @Fluff13 and @Bebo021999

You're welcome & thanks for the feedback.