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 curren...

excel

Formulas and Functions

Lorenzo Kim

Bronze Contributor

Oct 28, 2018

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..

Josh Moulton

Copper Contributor

Oct 28, 2018

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 too

Forum Discussion

Excel data formula help