Menu
Coddy logo textTech

Recap: Order Approval

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 10 of 28.

challenge icon

Challenge

Medium

Order amount is in B2, credit limit in C2, and account status Active or Blocked in D2. Return Approve in E2 only if the amount is positive, at most the credit limit, and the account is not Blocked. Otherwise return Review.

Enter formulas in the highlighted output cells: E2. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1
ABCDEFG
1OrderAmountLimitAccountDecision
2A80100Active
3
4
5
6
7
8
9
10
11
12
13
14

All lessons in Formulas and Data Analysis

Practice on your own: Excel playground