formulas
 

I am creating a chart that my spreadsheet totals go into. Here is an example
of one of my spreadsheets:
Mnth total qty ordered total qty shipped total scrap
JAN 456 455 1
FEB 898 877 21
MAR 345 321 24

I need the total scrap to be PPM - parts per million, so it will show up on
my chart. What kind of formula should I/can I use to turn the #'s in my
total scrap column into PPM?
PLEASE help me!!!

--
TJH

formulas
 

To comvert 1 in 456 to ppm is

1000000/456 * 1 = 2192.882 ppm

or as an Excel formula =(100000/A1)*A2

where A1 = production
and A2 = amount thrown away

"TJH" wrote:

I am creating a chart that my spreadsheet totals go into. Here is an example
of one of my spreadsheets:
Mnth total qty ordered total qty shipped total scrap
JAN 456 455 1
FEB 898 877 21
MAR 345 321 24

I need the total scrap to be PPM - parts per million, so it will show up on
my chart. What kind of formula should I/can I use to turn the #'s in my
total scrap column into PPM?
PLEASE help me!!!

--
TJH