Looking up prices in Grid

[RFrechette]

Is there someone out there that can either help me with this or point me to
an easy to understand website for help? (Wasn’t quite sure which forum to
post this in. Sorry if it’s not in the correct one.)

I am trying to figure out what price a client will have to pay based on the
volume they will do and whether they use B/W or Color.

It is based on the Grids below.
For B/W, they will be using either ItemNo 21003 or 72027.
For Color, they will be using either ItemNo 77100 or 77110.

For example,

Client is doing B/W and they do 1550 copies, the price for this job would be
0.26.
Client is doing Color and they do 575 copies, the price for this job would
be 0.75.

I know I can use “if†or “case†in code, but is there a way I can keep these
in some sort of table and reference them so it will be easier to change them
when needed?


B/W Grid (ItemNo 21003 or 72027)
Volume Price
0 - 500 0.35
501 - 1,000 0.30
1,001 - 1,500 0.28
1,501 - 2,500 0.26
2,501 - 5,000 0.16
5,001 - 7,500 0.14
7,501 - 10,000 0.12
10,001 - 15,000 0.10

15,000 0.08

Color Grid (ItemNo 77100 or 77110)
Volume Price
0 - 500 1.50
501 - 1,000 0.75

1,000 0.65

I would greatly appreciate any help you could give me.

Thanks,
Rachel