Repair the formula in E2 so every row reproduces the approved figures in D. 6 entries left.
Silent. No timer pressure.
11
E2 =
12
13
Audit note: Reps earn 15% commission when sales reach 40,000 or more, otherwise 5%. Round to 2 decimals. Column D holds the approved figures; the model formula in E was mangled in a bad merge. Reference the data columns only (A-C).
14
Toolbox: IF, MIN, MAX, ROUND, ABS, SUM, AVERAGE, AND, OR, NOT - cell refs like B2, ranges like B2:B9, operators + - * / ^ & = <> <= >=
15
Summary
Fix the formula, not the data. Syntax errors never cost an entry. Beat par length for a bonus.
