Code Format Validator

Hard ★★★

Update the output cells to display a "Valid" status for each code if the middle three characters of the code are numeric, and "Invalid" otherwise. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

Hint

Solution Approach

Past Submissions

Signup or login to make and view submissions. Your work will be saved.

A1 expected value: *

This cell cannot be edited

Code Format Validator

Hard ★★★

Update the output cells to display a "Valid" status for each code if the middle three characters of the code are numeric, and "Invalid" otherwise.

Your solution is tested against 3 test cases which you can toggle between. To pass, your solution should use cell references so it returns the correct output across test cases.