meeting 2 sets of criteria to enter value

I need to insert a cost based on 2 sets of criteria. If the disc type is "cd" and the qty is less than 5,000 then $1 - if its over 5,000, the $2. If the disc type is "dvd" and the qty is less than 5,000 then $3 - if its over 5,000, the $4. I cant seem to get everything right and need help!

[TABLE="width: 192"]

[tr]

[TD="class: xl63, width: 64"]Quantity [/TD]
[TD="class: xl63, width: 64"] Disc Type[/TD]
[TD="class: xl64, width: 64"] $$ [/TD]

[/tr]

[tr]

[TD="class: xl65, align: right"]1500[/TD]
[TD="class: xl65"] CD[/TD]
[TD="class: xl66"] [/TD]

[/tr]

[tr]

[TD="class: xl65, align: right"]1700[/TD]
[TD="class: xl65"] CD[/TD]
[TD="class: xl66"] [/TD]

[/tr]

[tr]

[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65"] CD[/TD]
[TD="class: xl66"] [/TD]

[/tr]

[tr]

[TD="class: xl65, align: right"]7400[/TD]
[TD="class: xl65"] dvd[/TD]
[TD="class: xl66"] [/TD]

[/tr]

[tr]

[TD="class: xl65, align: right"]2800[/TD]
[TD="class: xl65"] CD[/TD]
[TD="class: xl66"] [/TD]

[/tr]

[tr]

[TD="class: xl65, align: right"]3100[/TD]
[TD="class: xl65"] CD[/TD]
[TD="class: xl66"] [/TD]

[/tr]

[/TABLE]

Re: meeting 2 sets of criteria to enter value

Thank you!!!!