Formula Help Please

[VbaHell]

Hello all, I am using Excel 2007 and require help please with a calcualtion formula

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

 

[CodeNinja]

=IF(E2>=200,"No",IF(B2<(C2*2),IF(E2>=50,"No","Yes"),"Yes"))

 

[VbaHell]

CodeNinja

This seems not quite right, I have tried this but it is also not working

IF(OR(AND(D2<=-100,E2<=-200),AND(E2<=-50)),"NO","YES")



B2 = 410
C2 = 500
D2 = -21.95
E2 -= -90

ANSWER IS YES BECAUSE D2 IS GREATER THAN -100 AND E2 IS LESS THAN -200

B2 = 75
C2 = 160
D2 = -113.33
E2 -= -85

ANSWER IS NO BECAUSE D2 IS OVER -100

B2 = 290
C2 = 500
D2 = -72.41
E2 -= -210

ANSWER IS NO, D2 IS GREATER THAN -100 SO THAT WOULD MAKE THE ANSWER YES BUT E2 IS GREATER THAN -200

 

[anglais428]

What are you parameters for D2?

 

[CodeNinja]

Sorry, I misunderstood your scenarios....

=IF(E2<=-200,"No",IF(D2<-0.5,IF(E2<=-50,"No","Yes"),"Yes"))

or

=IF(E2<=-200,"No",IF(D2<-50,IF(E2<=-50,"No","Yes"),"Yes"))


Depending on whether you are marking the D2 as a percentage or actually putting in the number corresponding to the percentage

 

[anglais428]

=IF(E2>=-200,"No",IF(D2<-100,"No",IF(AND(B2<0.5*C2,E2>=50),"No","Yes")))

 

[VbaHell]

This is the calculation for D2
SUM(B2-C2)/B2*100

 

[VbaHell]

Thank you to you both for your help on this