Actually...G8 is a formula based on time giving me a gradual scale of how
many months a person has been employeed and H8 is a number that is manually
typed in each week.

"RCY2" wrote:

Just to make sure I understand you correctly.

G8 and H8 will be selectable list boxes?

and as a result of those 2 fields you want I8 to display either Successful,
Does not meet, or Inconsistent.

Is that correct?

"jonssmaster" wrote:

Ok, here's one that has me stumped and hoping someone can help. Let me see
if I can explain what I am trying to do. I have two conditions in cells C8 &
H8, both are numeric values. I8 will show a text value with the result of the
first two conditions. My problem is that this is a really large formula
because cell G8 is a range between 0 and 6 and H8 is a percentage. For
example...
G8 H8 I8
0-1 30-40% Successful
1-2 40-50% Successful
2-3 50-60% Successful
3-4 60-70% Successful
4-5 70-80% Successful
5-6 80-90% Successful
6+ <80% Does Not Meet
80-89% Inconsistent
90-114% Successful
Etc.
Any suggestions?