Bucket every applicant into a risk tier before the committee meets
Underwriting tags every applicant by risk before loan committee. Scores 750+ are Low, 650-749 are Medium, anything below 650 is High. The committee won't read the score — they read the tier.
Assign credit risk tier from credit score
Practice using IF to solve a real finance & accounting problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Credit underwriting tags every applicant by risk before the loan committee meets. Score 750 or higher is 'Low', 650-749 is 'Medium', anything under 650 is 'High'. The committee won't read the score — they read the tier.
In cell E2, return 'Low' if the credit score in D2 is 750 or higher, 'Medium' if it's 650 or higher, otherwise 'High'. Drag the formula down through E9 so every applicant is bucketed.
IF tests a condition and returns one value if it's true and another if it's false. It's the foundation of every conditional formula in Excel. The condition can use comparison operators (=, <, >, <>), and the two return values can be numbers, text, blanks, or even nested formulas.
IF(logical_test, value_if_true, [value_if_false])Try the formula first. Hints cost CP for a reason.