# Thread: Oh dear heavens...I've been on this same question for DAYS!!! Thanks: 0 Likes: 0

1. ## Oh dear heavens...I've been on this same question for DAYS!!!

A company will be able to obtain a quantity discount on component parts for its three products, X1, X2 and X3 if it produces beyond certain limits. To get the X1 discount it must produce more than 50 X1's. It must produce more than 60 X2's for the X2 discount and 70 X3's for the X3 discount. Which of the following pair of constraints enforces the quantity discount relationship on X3?

2. ## Re: Oh dear heavens...I've been on this same question for DAYS!!!

=IF(X3>=70,X3Disc,IF(X2>60,X2Disc,IF(X1>50,X1Disc,NoDisc)))

3. ## Re: Oh dear heavens...I've been on this same question for DAYS!!!

For clarity ~

You have 3 columns C,D and E
in C you have X1, in D you have X2, in E you have X3.
Your Discount rate is named in your Name manager for each product as in the Formula.
Your formula would then look like this in another column.

If your 1st row of data was in row 3.

=IF(E3>=70,X3Disc,IF(D3>60,X2Disc,IF(C3>50,X1Disc,"NoDiscount")))

4. ## Re: Oh dear heavens...I've been on this same question for DAYS!!!

Hmmm...so I'm confused....I have to choose between these answers

A. X31 < M3Y3, X32 > 50Y3
B. X31 < M3Y3, X31 > 50
C. X32 > (1/50)X31, X31 < 50
D. X32 < M3Y3, X31 > 50Y3

5. ## Re: Oh dear heavens...I've been on this same question for DAYS!!!

IF you want different discount rates depending on quantity for each separate product
So new formula for each product

If product X3 was in column E3

=IF(E3>=70,X3Disc3,IF(E3>60,X3Disc2,IF(E3>50,X3Disc1,"NoDiscount")))

Do the same for the other products changing the references to suit.

I don't follow this, what it all refers to (in relation to X1,X2 and X3)
A. X31 < M3Y3, X32 > 50Y3
B. X31 < M3Y3, X31 > 50
C. X32 > (1/50)X31, X31 < 50
D. X32 < M3Y3, X31 > 50Y3

What is M3Y3 for instance is it range references, products or what?

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•