Information › ISNUMBER127 / 144

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

EasyFreeISNUMBER

ISNUMBER: check the stock count entries

During a stock count at a stationery warehouse in Bogor, some staff typed quantities as text, such as "12 pcs" or "-". As a result, the SUM of the stock comes out lower than it should. The warehouse head wants to flag which entries are real numbers.

Task

Fill C2:C7 with TRUE if the quantity in column B is a number, otherwise FALSE. Use ISNUMBER.

Cells to fillC2:C7

Required functionsISNUMBER

Expected result

Loading the expected result…

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

Hint 1
ISNUMBER(value) returns TRUE if the value is a number, and FALSE for text, empty cells, or logical values.
Hint 2
Zero is still a number, so it gives TRUE. Text like "12 pcs" is not a number even though it contains digits.
Hint 3
Refer to the quantity cell in the same row, then fill the formula down to row 7.

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

=ISNUMBER(B2)

Write it in C2, then fill down to C7.

Explanation

=ISNUMBER(B2) separates real numbers from text. "12 pcs" is text because it has letters, so SUM ignores it. Dates also count as numbers for ISNUMBER, because Excel stores dates as serial numbers. Tip: use ISNUMBER in conditional formatting to highlight mistyped cells, then fix the data at the source.

Starting worksheet: Sheet1
Row	A	B	C
1	Item	Qty	Number?
2	Notebook, 38 sheets	120
3	Black pen	12 pcs
4	2B pencil	45
5	Eraser	-
6	30 cm ruler	0
7	Whiteboard marker	none left
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result