IF with AND

Intermediate

Loan decisions often depend on multiple conditions at once. In Excel, you can combine conditions with AND, then use IF to return the decision you want.

AND returns TRUE only when all tests are TRUE. You’ll typically use it inside IF to create a single decision rule.

What you need to do:

In column E (Decision), return "Approve" only when both of these are true:
- Credit score is greater than 700
- Annual income is greater than 50,000
Otherwise, return "Decline".
Write the formula in E2, then fill it down through E11.

Use the values in each row (credit score and income) as your references.

Need some help?

Hint 1

Start by building the logical test with AND: one comparison for credit score and one for income.

Hint 2

Wrap that AND test in IF so you return "Approve" when it’s TRUE and "Decline" when it’s FALSE.

Hint 3

Double-check the boundary cases: 700 is not greater than 700, and 50,000 is not greater than 50,000.

Related function(s)

IF AND OR IFS IFERROR

More exercises

IF with ORIntermediate

Nested IF for gradingIntermediate

Nested IF for commission tiersIntermediate

Complex commission structureAdvanced

Back to exercises overview

Exercise

IF with AND

Intermediate

Loan decisions often depend on multiple conditions at once. In Excel, you can combine conditions with AND, then use IF to return the decision you want.

AND returns TRUE only when all tests are TRUE. You’ll typically use it inside IF to create a single decision rule.

What you need to do:

In column E (Decision), return "Approve" only when both of these are true:
- Credit score is greater than 700
- Annual income is greater than 50,000
Otherwise, return "Decline".
Write the formula in E2, then fill it down through E11.