Can someone help me figure this out?

I have two sheets,
1. Pricing
2. Ordering

On the "Ordering" sheet I have to enter numbers of sheets to print for
a customer. Based off of the number of sheets someone wants me to
print, I have to goto my "Pricing" sheet, and look to see which pricing
category it will fall under.

For example:

I have a print job for 250 pages, now I have to create a formula that
will goto my "Pricing" sheet, and look through the following
conditions.
----------------------------------------------------------------------
PRICING SHEET

From To Charge Amount

1 99 $0,100
100 249 $0,090
250 499 $0,080
500 999 $0,070
1000 2499 $0,060
2500 4999 $0,050
5000 7499 $0,048
7500 9999 $0,046
10000 12499 $0,044
12500 14999 $0,042
15000 17499 $0,040
17500 19999 $0,038
20000 22499 $0,036
22500 24999 $0,034
25000 27499 $0,032
27500 29999 $0,030
30000 60000 $0,028
----------------------------------------------------------------------
I tried doing this as an IF statement, but I soon realized that you can
only nest up to 7 IF's. :( I tried to create 3 Nested IF formulas by
following this example and I kept on recieving errors.
http://www.cpearson.com/excel/nested.htm

This what I created, but am not quite understanding exactly how to get
things to work this is my poor excuse for a Select Case:
----------------------------------------------------------------------
Sub bwo()
Dim clicks As Integer
Select Case clicks

Case Is = 1, Is <= 99
clicks = 100
Case Is = 100, Is <= 249
clicks = 90
Case Is = 250, Is <= 499
clicks = 80
Case Is = 500, Is <= 999
clicks = 70
Case Is = 1000, Is <= 2499
clicks = 60
Case Is = 2500, Is <= 4999
clicks = 50
Case Is = 5000, Is <= 7499
clicks = 48
Case Is = 7500, Is <= 9999
clicks = 46
Case Is = 10000, Is <= 12499
clicks = 44
Case Is = 12500, Is <= 14999
clicks = 42
Case Is = 15000, Is <= 17499
clicks = 40
Case Is = 17500, Is <= 19999
clicks = 38
Case Is = 20000, Is <= 22499
clicks = 36
Case Is = 22500, Is <= 24999
clicks = 34
etc....

End Select
End Sub
----------------------------------------------------------------------

Based off of the number from my "Order" sheet I need to check it with
the pricing range to see which category my value falls under from my
example of 250 the price that I should apply is 80 dollars, and then
apply this price to the field on the "Ordering" sheet in a Cell.

I hope I didn't butcher this explanation, I tried to give as much info
as I can.

Someone please help me.........

Alen