 • 467K Members
• 12.6K Online
• 565K Conversations

# 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.
"
7 Replies

# Re: Excel data formula help

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

# Re: Excel data formula help

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

# Re: Excel data formula help

pls see attached file..

# Re: Excel data formula help

The cell c3... 2862 was the starting number on the previous page. So it is (30 x 2) plus 2862.
"Total" is just the pieces ran added together so on the previous page it was at 18 so we added 30 to 18 and got the total number.
Again thanks for helping

# Re: Excel data formula help

pls see attached file..

# Re: Excel data formula help

The Blue numbers are not important they are just the serial number of the different inductors.

Yes there are previous pages. Each of the inductors started at 0 at one point.

# Re: Excel data formula help

pls see attached file..

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies