Information › ISODD129 / 144

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

MediumFreeISODD

ISODD: Jakarta's odd-even plate rule

Jakarta applies an odd-even rule on several roads: on odd dates only cars with odd plate numbers may pass, and on even dates only even plates. The general affairs team of an office in South Jakarta checks which company cars may pass on the date in F1.

Task

Fill C2:C6 with TRUE if the car may pass, meaning the plate number (column B) and the date in F1 are both odd or both even, otherwise FALSE. Use ISODD.

Cells to fillC2:C6

Required functionsISODD

Expected result

Loading the expected result…

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

Hint 1
ISODD(number) returns TRUE if the number is odd. A car may pass when ISODD of the plate equals ISODD of the date.
Hint 2
A date in Excel is a long serial number (21/10/2026 = 46316), so first take the day of the month (1 to 31) with DAY.
Hint 3
Compare two ISODD results with =, like =ISODD(B2)=ISODD(…), and lock F1 with $.

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

=ISODD(B2)=ISODD(DAY($F$1))

Write it in C2, then fill down to C6.

Explanation

Comparing two logical values with = returns TRUE when they match, whether both are TRUE (odd) or both are FALSE (even). Common mistake: applying ISODD($F$1) directly to the date. The serial number 46316 is even, while the 21st is odd, so every answer flips. The full plate number works fine because its parity is the same as its last digit. Its sibling, ISEVEN, returns the opposite of ISODD.

Starting worksheet: Sheet1
Row	A	B	C	E	F
1	Car	Plate number	May pass	Date	21/10/2026
2	B 1234 KJT	1234
3	B 2751 TRX	2751
4	B 1009 PQR	1009
5	B 8820 SDA	8820
6	B 4517 UVW	4517
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result