Day 84 · Monday, 26 October 2026
OR gives an applicant two separate paths to automatic approval, and nesting AND inside the second path lets that one path demand two conditions at once without IF needing a third branch to hold it.
You screen mortgage pre-approval applications for a credit union. Underwriting guidelines approve an applicant automatically if their credit score is 740 or higher. Below that, an applicant still qualifies if their credit score is at least 680 and their debt-to-income ratio is 36% or under — both of those have to hold at once. Anyone who clears neither path gets referred to a human underwriter instead of an automatic decision. In column D, use IF together with OR and AND to mark each applicant "Approved" or "Needs Review". Fill in rows 2 through 7.
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.