Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sudden "0" output on Sumproduct formulas | Excel Discussion (Misc queries) | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |