Thread: Formula help needed for multiple criteria & sheets

Example of what I need:

Columns:
A- Qty
G- $ x 1.15
I- 135 / Qty
J- 85 / Qty
K- 60 / Qty
L- $ x 1.15
N- $ per each
O- Total $


I need to be able to key in a number in the cells above, have the keyed in number displayed in the cell and for the formulas to be used with the results put on another worksheet.

Example of what is keyed in:

A- 5
G- $5.00
I- 1
J- 1
K- 10
L- $3.00
N- $168.20


Example of what needs to be displayed on the second worksheet:

A- 5
G- $28.75
I- 135
J- 60
K- 600
L- $3.00
N- $168.20
O- $841.00


I think there is going to be 3 different worksheets.
One will have the keyed in info. This is basically everything per item.
Second will have the results or rather, will have the info keyed in on first worksheet combined with the formulas (*1.15 or the qty divided by 60..etc)
And then the last worksheet will have the look up values. The (*1.15 or the qty divided by 60..etc).

The last worksheet will need to be live- the values may change. For example, maybe the 60 will be increased.. and so on.


Thanks in advance for any help!

To start:
1. Select sheet 2

2. In cell A1, type an equals sign, then without pressing Enter or tabbing out of the cell, select sheet 1, cell A1, press enter. Notice that you are back on sheet 2 with the formula =Sheet1!A1 in cell A1.
Go to sheet 1 and type a value in A1 and notice that it will have been copied into cell A1 on sheet 2.

3. Do the same for the other calculations you wish to make. For instance, on sheet 2 cell A2, enter = 5*, select sheet 1, cell A2 and press enter.

Type a value in sheet1, A2 and notice that sheet 2, A2 will show that value multiplied by 5. Thus so, continue....

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save