For simplicity, I will refer to the different sets as 1, 2, and 3. (1 being
keyed info, 2 being dispalyed formula, 3 being resultant)

A2
=A1
G2
=G1&" x 1.15"
I2
=I1&" / "&A1
J2
=J1&" / "&A1
K2
=K1&" / "&A1
L2
=L1&" x 1.15"
N2
=N1


For your formulas, simply write the math operation using * and /
Example
G3
=G1*1.15
I3
=I1/A1

And so on. Hopefully, you get the idea now.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"RockyFTI" wrote:


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!


--
RockyFTI
------------------------------------------------------------------------
RockyFTI's Profile: http://www.thecodecage.com/forumz/member.php?userid=417
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106146