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?