Basics & operators2 / 67

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFree

Target achievement percentage and gap

Mr. Hendra leads the sales team of a bottled water distributor in Surabaya. At the end of every month he compares each salesperson's actual sales with their target.

Task

In D2:D6, calculate the achievement percentage (actual divided by target); column D is already formatted as a percentage. In E2:E6, calculate the gap (actual - target), so salespeople below target get a negative number. Write the formulas on row 2 and copy them down.

Cells to fillD2:D6E2:E6

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Achievement = actual ÷ target. No need to multiply by 100, because the percentage format already shows 1.1 as 110%.
Hint 2
For Ayu, the actual is in C2 and the target in B2. The gap only needs the subtraction operator -.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

D2:D6

=C2/B2

Write it in D2, then fill down to D6.

E2:E6

=C2-B2

Write it in E2, then fill down to E6.

Explanation

=C2/B2 returns 1.1 for Ayu, and the 0.0% format shows it as 110.0%. A common mistake is writing =C2/B2*100: the result becomes 11,000% because the percentage format already multiplies by 100. =C2-B2 gives a negative number for Bima and Gilang, who are below target, so they are easy to highlight with conditional formatting.

Starting worksheet: Sheet1
Row	A	B	C	D	E
1	Sales	Target	Actual	Achievement	Gap
2	Ayu	120,000,000	132,000,000
3	Bima	100,000,000	87,500,000
4	Citra	150,000,000	150,000,000
5	Fajar	90,000,000	99,900,000
6	Gilang	110,000,000	82,500,000
7
8
9
10
11
12
13
14

Fill in the requested cells, then press Check answer.

Validation result