Forum Discussion
Excel data formula help
I have this paper I would like to input into a excel sheet so when someone add the number to the "pcs ran" it automatically completes the rest.
"Ind 1 X 2" would be pcs ran time 2 added to the current number in the line above it. How can I do this.
"
"Ind 1 X 2" would be pcs ran time 2 added to the current number in the line above it. How can I do this.
"
7 Replies
would you kindly explain further your query.
like, what is the unit of "PC RAN"?
the value of row above it: "71516" - what is this?
what is the meaning of "IND 1 X 2"?
how is the "TOTAL" computed?
and so on, so that people here at the forum can have a better view of your problem.
thanks..
- Pcs run is just the number of product that was ran
Ind 1 X 2 means it runs 2 times per product ran
Ind 2 X 4 means it runs 4 times per product ran
Ind 3 X 3 means it runs 3 times per product ran
Ind 4 X 2 means it runs 2 times per product ran
Ind 5 X 1 means it runs 1 time per product ran
Ind 6 X 1 means it runs 1 time per product ran
So say 10 products are ran
Ind 1 is (10 x 2) then added the current total located above
Ind 2 is (10 x 4) then added the current total located above
Ind 3 is (10 x 3) then added the current total located above
Ind 4 is (10 x 2) then added the current total located above
Ind 5 is (10 x 1) then added the current total located above
Ind 6 is (10 x 1) then added the current total located above
I want it so when someone adds a new total to the "pcs ran" it will automatically fill out the rest of the row.
Let me know if I need to give anymore and Thanks toopls see attached file..
