Add condition to existing formula

[Ozhatch]

I have this formula in column K: =IF(AND(H6>=1000,J6<=10%),"Yes","No") Now I want to add a further condition.

If the word "None" appears in column E, Column K should return "No". In any other condition in column E, column K should return "Yes".

Please would some kind expert edit the formula for me?

Thanks very much.

 

[Fluff]

What happens if there is a discount in G & E says None?

 

[Ozhatch]

Bonus is not payable.

 

[Fluff]

Ok, it's not the formula that's at fault, it's the conditional formatting "hidding" the value in col K if G is 0

 

[Ozhatch]

Thanks very much, Fluff! That's easily solved by moving G to a different column.

All working perfectly now. I really appreciate all your assistance on this.

 

[Fluff]

Glad to help & thanks for the feedback