Logic › NOT39 / 144

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

EasyFreeNOT

NOT: who needs a rent reminder

Mr. Joko runs a boarding house in Malang. Every month he marks column C with TRUE for tenants who have paid their rent. He wants column D to flag the tenants who need a WhatsApp reminder, which is the opposite of column C.

Task

Fill D2:D7 with TRUE for tenants who have not paid and FALSE for those who have. Use NOT.

Cells to fillD2:D7

Required functionsNOT

Expected result

Loading the expected result…

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

Hint 1
NOT flips a logical value: TRUE becomes FALSE, and FALSE becomes TRUE.
Hint 2
Column C already holds logical values, so it can go straight into NOT without any comparison.
Hint 3
Write the formula in D2 with the payment-status cell from the same row as its only argument, then fill it down to D7.

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:D7

=NOT(C2)

Write it in D2, then fill down to D7.

Explanation

=NOT(C2) flips the payment status: tenants who have not paid (FALSE) become TRUE in the reminder column. =C2=FALSE gives the same result, but NOT reads more clearly. NOT gets more useful in combinations, such as NOT(OR(…)) for "none of the conditions are met". Tip: a TRUE/FALSE column like this works well with filters and conditional formatting.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Room	Tenant	Paid	Needs reminder
2	K-01	Andre	TRUE
3	K-02	Melati	FALSE
4	K-03	Yusuf	TRUE
5	K-04	Tiara	FALSE
6	K-05	Gilang	TRUE
7	K-06	Putra	FALSE
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result