Multiple IF & +IF commands

I've attached the spreadsheet I'm working on.

I don't know if this can be done or not, but I need column "Q" to do a couple of things.

1.) It should take the amount using numbers (1 - 8) in column "N" and multiply Column "AD3" (So 1 * 2500 or 2 * 2500...etc)
2.) Column "O" would be a number from (1 - 6). As the number in this column goes up 1,2,3,4,5,6, the volume from Column "N" would decrease by multiplying the following:
1 = 2
2 = 1.75
3 = 1.5
4 = 1.25
5 = 1
6 = .75

I hope I've explained this correctly.

Your formula in Q10 implies the numbers in column O can range from 0 to 6, with factors from 2 to 0.5, so what's it to be?

If that is correct, then you can use this formula in Q3:

=$AD$3*N3*(9-O3-1)/4

then copy it down. If the range of numbers is as you state in your post, then you can omit the -1 from the formula.

Hope this helps.

Pete