Math & trig › INT12 / 144

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

EasyFreeINT

INT: co-op member points

The Sejahtera Employee Cooperative mini market in Bekasi gives 1 point for every full Rp10,000 spent. Any remainder under Rp10,000 earns no points. Dewi, the co-op admin, wants to calculate the points of each member.

Task

Fill C2:C6 with the number of points: total spending (column B) divided by 10000, then rounded down to a whole number with INT.

Cells to fillC2:C6

Required functionsINT

Expected result

Loading the expected result…

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

Hint 1
INT(number) drops the decimal part and rounds down, for example INT(18.75) = 18.
Hint 2
Divide the spending by 10000 inside INT. Type the number without thousands separators.
Hint 3
Pattern: =INT(spending/10000), with the spending in B2.

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

C2:C6

=INT(B2/10000)

Write it in C2, then fill down to C6.

Explanation

=INT(B2/10000) divides the spending by 10,000 and drops the decimals, so Rp187,500 becomes 18 points, not 19. For positive numbers it gives the same result as ROUNDDOWN(B2/10000,0). Be careful with negative numbers: INT(-2.5) returns -3 because INT always rounds down. ROUND would be wrong here because 18.75 rounds to 19.

Starting worksheet: Sheet1
Row	A	B	C
1	Member	Total spending	Points
2	Pak Budi	187,500
3	Bu Ratna	52,000
4	Yoga	9,800
5	Wulan	1,250,000
6	Om Joko	349,900
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result