Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a forcasting type problem
I am trying to have excel do a few automatic calculations for me. In the
problem I am trying to solve I have the following: Given: Month (day 1-31) production each day (ranges from 0-3000 value is linked from another file) life of a tool (consider 10,000 before it needs changed) Find: Have a cell change color using (format cell) when tool life is up. I have been able to do this for an entire month worth of projected production (dividing it evenly into the number of production days) but have not been able to use a forcast funtion. I really do not care what funtion I use to do this just that I can expand this into a larger project with multiple tools (say 75) each with the posibility of differnt life expectancies. Thanks for any help someone can offer. -- Brake-Man2008 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart type problem | Charts and Charting in Excel | |||
Forcasting for a multiyear period | Excel Discussion (Misc queries) | |||
how do I multiply dollars by networkdays for forcasting run rates | Excel Worksheet Functions | |||
Data Type Problem? | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions |