Hi Everyone,
Heres the problem. I'm trying to schedule maintenance based on the number of times the
equipment starts. But the type of Maintenance varies based on the the number of Equipment starts (which vary year to year).
assume: 400 starts = "A"
800 starts = "A"
1200 starts = "B"
1600 starts = "A"
2000 starts = "A"
2400 starts = "C"
years: 1 2 3 4 5
Starts 100 404 443 1250 2460
cells c19 d19 e19 f19 g19
the current formula I'm using works but only
for one event. (See Below) I'm not real good at nesting and I'm not sure thats the answer.
=IF(AND(399<C19,C19<450), "A", "----")
result in c19 would be "----"
If applied to the other cells the
result in d19 would be "A"
result in e19 would be "A" (also a problem)
result in f19 would be "----"
result in g19 would be "----"
Basically, Looking for a way to check for all
the above assumptions and return the correct
event (A,B or C) with out duplication of a event like e19 shows.
Anybody got any ideas?
Jim
Heres the problem. I'm trying to schedule maintenance based on the number of times the
equipment starts. But the type of Maintenance varies based on the the number of Equipment starts (which vary year to year).
assume: 400 starts = "A"
800 starts = "A"
1200 starts = "B"
1600 starts = "A"
2000 starts = "A"
2400 starts = "C"
years: 1 2 3 4 5
Starts 100 404 443 1250 2460
cells c19 d19 e19 f19 g19
the current formula I'm using works but only
for one event. (See Below) I'm not real good at nesting and I'm not sure thats the answer.
=IF(AND(399<C19,C19<450), "A", "----")
result in c19 would be "----"
If applied to the other cells the
result in d19 would be "A"
result in e19 would be "A" (also a problem)
result in f19 would be "----"
result in g19 would be "----"
Basically, Looking for a way to check for all
the above assumptions and return the correct
event (A,B or C) with out duplication of a event like e19 shows.
Anybody got any ideas?
Jim