|
-
Feb 8th, 2011, 02:24 PM
#1
Thread Starter
Addicted Member
[RESOLVED] Excel cell formula problem
I am creating this long formula and it works fine until I add the last couple of conditions. I don't see anything wrong, any ideas??? It isn't past the 30 condition limit, but what do I know..
=IF(OR(F8="LOW",G8="LOW"),"LOW",IF(AND(F8="MEDIUM",G8="VERY
HIGH"),"MEDIUM",IF(AND(F8="MEDIUM",G8="HIGH"),"MEDIUM",IF(AND(F8="MEDIUM",G8="MEDIUM"),"MEDIUM",
IF(AND(F8="HIGH", G8="VERY HIGH"),"HIGH",IF(AND(F8="HIGH",G8="HIGH"),"HIGH",IF(AND(F8="HIGH",
G8="MEDIUM"),"MEDIUM",IF(AND(F8="VERY HIGH", G8="VERY HIGH"),"VERY HIGH",IF(AND(F8="VERY HIGH",
G8="HIGH"),"HIGH",IF(AND(F8="VERY HIGH", G8="MEDIUM"),"MEDIUM", "ELSE")))))))
From the underlined AND on it doesn't like this, but if I remove from that point on, it is ok. I need all these conditions!!!!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|