Complex Logical Combinations
Combine multiple logical functions for complex conditions.
Task:
You are evaluating loan applications based on multiple criteria: income, credit score, and debt ratio. Determine loan approval in column E based on the criteria: Income > $50,000 AND Credit Score > 700 AND Debt Ratio < 0.3.
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of Complex Logical Combinations
0/4The same formula in the other shapes it takes at work.
- Complex Logical Combinations
Combine multiple logical functions for complex conditions.
CoreAdvanced - OR of two ANDs: two routes to yes
Approved either on the numbers, or on a guarantor — two complete rules joined.
Advanced - Count how many conditions are met
TRUE counts as 1 in arithmetic, so conditions can be added up.
Advanced - At least two of three
A majority rule that AND and OR cannot express on their own.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Applicant | Income | Credit Score | Debt Ratio | Approved |
| 2 | John | 75000 | 720 | 0.25 | |
| 3 | Mary | 45000 | 680 | 0.35 | |
| 4 | Tom | 85000 | 750 | 0.2 | |
| 5 | Sarah | 55000 | 650 | 0.4 |
What this exercise teachesMay contain the answer
Complex logical combinations allow for sophisticated decision-making rules by combining functions like IF, AND, and OR to evaluate multiple criteria.