I am trying to make a form in excel which will do some calculations. There
is a table with numbers. There is a column A which will contain a base,
Column B will contain a quantity which will be multiplied against a number in
the table, Columns C, D, and E will give the results of multiplying B, by
number in table resulting in row from base. I am trying if statement but lot
of if statements, is there an easy way to do this?

# PAGES QUANTITY LTR 1-SIDED LTR 2-SIDED LGR 2-SIDED



TABLE:

# PAGES LTR 1-SIDED LTR 2-SIDED LGR 2-SIDED
2 1
3 1
4 1
5 1 1
6 1 1
7 2
8 2
9 1 2
10 1 2
11 3
12 3
13 1 3
14 1 3



THE RESULT I AM LOOKING FOR:
PUT in # pages (2 pages), QTY (Varies), result would contain quantity under
last 3 columns,

ex.

# PAGES QUANTITY LTR 1-SIDED LTR 2-SIDED LGR 2-SIDED
3 100 100
8 200
400 (200 * 2)