If the Selling price is <50% of the cost price and the value loss is => 50.00 then the answer is "No" otherwise "Yes"

Also not taking into account the above if there is a straight loss =>200.00 then "No" othwise "Yes"

B2 = Selling Price

C2 = Cost Price

D2 = Margin %

E2 = Value

I can change the cells or add more formula's if needed