Day 84 · Monday, 26 October 2026

From the archive

Advanced

Screen Mortgage Pre-Approvals by Wrapping AND Inside OR

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.

Task:

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.

The daily challenge is part of Pro

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.