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)

It's a little difficult to see what your tables really look like, the layout
has gotten screwed up by the system here, as usual.

I'm not sure you really need the table to look things up, couldn't you build
a general formula for each situation (LTR 1 Sided, LTR 2-Sided, LGr 2-Sided)
into the table where you're entering # Pages and Quantity? I'm not certain
what the 'factor' is for going to the LGR sheets, but the LTR sheets would
seem to be simple enough

A B C D
E
1 # Pages .... Quantity L 1-S L 2-S LG 2-S
2 1 1 =A2*B2 =ROUNDUP(A2*B2/2,0)

and the last formula, for E2, might be something like =ROUNDUP(A2*B2/1.5,0)
but I'm not sure what the 1.5 really should be.
Given those formulas, I'd get results like:

#P QTY L 1-S L 2-S LGR 2-S
1 1 1 1 1
1 100 100 50 67
3 100 300 150 200

But if that doesn't work, look into the VLOOKUP() Function instead of using
a ton of nested IF() statements for access into the other table.


"supernerd101" wrote:

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)

Thanks, I used the VLOOKUP() and got it to work.


"JLatham" wrote:

It's a little difficult to see what your tables really look like, the layout
has gotten screwed up by the system here, as usual.

I'm not sure you really need the table to look things up, couldn't you build
a general formula for each situation (LTR 1 Sided, LTR 2-Sided, LGr 2-Sided)
into the table where you're entering # Pages and Quantity? I'm not certain
what the 'factor' is for going to the LGR sheets, but the LTR sheets would
seem to be simple enough

A B C D
E
1 # Pages .... Quantity L 1-S L 2-S LG 2-S
2 1 1 =A2*B2 =ROUNDUP(A2*B2/2,0)

and the last formula, for E2, might be something like =ROUNDUP(A2*B2/1.5,0)
but I'm not sure what the 1.5 really should be.
Given those formulas, I'd get results like:

#P QTY L 1-S L 2-S LGR 2-S
1 1 1 1 1
1 100 100 50 67
3 100 300 150 200

But if that doesn't work, look into the VLOOKUP() Function instead of using
a ton of nested IF() statements for access into the other table.


"supernerd101" wrote:

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)

Glad that I was at least able to offer a helpful hint.

"supernerd101" wrote:

Thanks, I used the VLOOKUP() and got it to work.


"JLatham" wrote:

It's a little difficult to see what your tables really look like, the layout
has gotten screwed up by the system here, as usual.

I'm not sure you really need the table to look things up, couldn't you build
a general formula for each situation (LTR 1 Sided, LTR 2-Sided, LGr 2-Sided)
into the table where you're entering # Pages and Quantity? I'm not certain
what the 'factor' is for going to the LGR sheets, but the LTR sheets would
seem to be simple enough

A B C D
E
1 # Pages .... Quantity L 1-S L 2-S LG 2-S
2 1 1 =A2*B2 =ROUNDUP(A2*B2/2,0)

and the last formula, for E2, might be something like =ROUNDUP(A2*B2/1.5,0)
but I'm not sure what the 1.5 really should be.
Given those formulas, I'd get results like:

#P QTY L 1-S L 2-S LGR 2-S
1 1 1 1 1
1 100 100 50 67
3 100 300 150 200

But if that doesn't work, look into the VLOOKUP() Function instead of using
a ton of nested IF() statements for access into the other table.


"supernerd101" wrote:

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)