OR of two ANDs: two routes to yes
Approved either on the numbers, or on a guarantor — two complete rules joined.
Task:
A tenancy is approved if the applicant earns over 30,000 and has a credit score over 650, or if they have a guarantor whatever their numbers. In E2:E7 show Approve or Decline.
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 | Guarantor | Decision |
| 2 | T1 | 42000 | 710 | No | |
| 3 | T2 | 28000 | 720 | Yes | |
| 4 | T3 | 35000 | 600 | No | |
| 5 | T4 | 19000 | 580 | No | |
| 6 | T5 | 31000 | 651 | No | |
| 7 | T6 | 30000 | 700 | No |
What this exercise teachesMay contain the answer
Write the rule the way it is spoken: (this and that) or the other. Nesting AND inside OR keeps each route intact; flattening it into OR(B2>30000,C2>650,D2="Yes") would approve anyone with a decent credit score alone. T6 earns exactly 30,000, which is not over it.