excelidiotSC
New Member
- Joined
- Dec 22, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi. I have a simple spreadsheet for scheduling periodic PM work for 95 injection molding machines at my plant.
Brief setup:
We have two levels of PM work, based on machine cycles:
· 1,000,000 Cycles = Lvl 10 PM
· 2,000,000 Cycles = Lvl 20 PM
If we perform a 20 on a machine, then the next PM will be a 10 and vice versa.
However, in case a machine doesn't run very often, we have to perform a Lvl 20 PM at least once a year.
SO... in the below spreadsheet example, how do I write a logic-based formula that will read the value in Column H (either 10 or 20) and generate the appropriate value in Column E, given the Date entered in Column I?
I could see the following logic statements being true and possibly helpful:
· If Hx>10, then Ex=10
· But, if Ix< Today minus 365days, then Ex=20
Unfortunately, IT won't allow me to install XL2BB.
And, yes, I know we're rather behind on PM work... Haha
--Steve
Brief setup:
We have two levels of PM work, based on machine cycles:
· 1,000,000 Cycles = Lvl 10 PM
· 2,000,000 Cycles = Lvl 20 PM
If we perform a 20 on a machine, then the next PM will be a 10 and vice versa.
However, in case a machine doesn't run very often, we have to perform a Lvl 20 PM at least once a year.
SO... in the below spreadsheet example, how do I write a logic-based formula that will read the value in Column H (either 10 or 20) and generate the appropriate value in Column E, given the Date entered in Column I?
I could see the following logic statements being true and possibly helpful:
· If Hx>10, then Ex=10
· But, if Ix< Today minus 365days, then Ex=20
Unfortunately, IT won't allow me to install XL2BB.
And, yes, I know we're rather behind on PM work... Haha
--Steve