#### VbaHell

##### Well-known Member
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

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
=IF(E2>=200,"No",IF(B2<(C2*2),IF(E2>=50,"No","Yes"),"Yes"))

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

What are you parameters for D2?

=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

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

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

Thank you to you both for your help on this

Replies
5
Views
177
Replies
15
Views
492
Replies
7
Views
179
Replies
3
Views
802
Replies
2
Views
156

1,196,337
Messages
6,014,706
Members
441,838
Latest member
ykg1991

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back