Logic › IF12 / 67

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

EasyFreeIF

IF: boarding room rent status

Mrs. Rahma runs a six-room boarding house for female students in Purwokerto. Every 10th of the month she checks who has paid the full rent so she can remind those who have not.

Task

In E2:E7, write Paid if the amount paid is equal to or greater than the rent, otherwise Unpaid. Use IF, write it in E2 and copy it down to E7.

Cells to fillE2:E7

Required functionsIF

Expected result

Loading the expected result…

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

Hint 1
The shape is IF(condition, value_if_true, value_if_false).
Hint 2
The condition compares column D with column C using >=. The text results go in quotes.
Hint 3
Pattern: =IF(D2>=C2, "…", "…").

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

E2:E7

=IF(D2>=C2,"Paid","Unpaid")

Write it in E2, then fill down to E7.

Explanation

=IF(D2>=C2,"Paid","Unpaid") also returns Paid for Dinda, who paid extra, because the condition is >=, not =. With =, an overpayment would be treated as unpaid. The result text must be typed exactly, including capitalization. Google Sheets tip: one formula =ARRAYFORMULA(IF(D2:D7>=C2:C7,"Paid","Unpaid")) in E2 fills every row at once.

Starting worksheet: Sheet1
Row	A	B	C	D	E
1	Room	Tenant	Rent	Paid amount	Status
2	A1	Laras	850,000	850,000
3	A2	Nabila	850,000	500,000
4	B1	Tiara	950,000	950,000
5	B2	Maya	950,000	0
6	C1	Yuni	1,100,000	1,100,000
7	C2	Dinda	1,100,000	1,200,000
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result