The examples I gave of conditions not catered for in post #4 were just two or numerous possibilities that you hadn't addressed and, without knowing about what is expected of them, we can't provide a solution. You need to tell us what the expected output is for all 9 possible results:
• A < 120 & B < 80
• A >= 120-<140 & B < 80
• A>= 140 & B < 80
• A < 120 & B >= 80-<90
• A >= 120-<140 & B >= 80-<90
• A> 140 & B >= 80-<90
• A < 120 & B > 90
• A >= 120-<140 & B > 90
• A>= 140 & B > 90
So far, you've managed to address only 5 of the 9 possible results.
Cross-posted at:
Nested if condition - MS Answers
if statement - Conga Salesforce nested if condition - Stack Overflow
For cross-posting etiquette, please read:
A message to forum cross posters - Excelguru