NOTNUMBER

[schardt679]

NOTNUMBER returns TRUE or FALSE if a cell in a given range is not a number.

Other functions on minisheet: AFORMULATEXT.

Screen Tip/ Comment: =NOTNUMBER(Array☛ range to check if cells aren't numbers)

=LAMBDA(Array,
      --(ISNUMBER(Array))=0
  )

LAMBDA Examples.xlsx
	A	B	C	D	E	F	G
1		NOTNUMBER
2
3		Original Data			Result
4		1			FALSE	TRUE
5			2		TRUE	FALSE
6		#N/A			TRUE	TRUE
7		ABC			TRUE	TRUE
8		3	ABC		TRUE	TRUE
9
10		B5 & C6 contain space(s)
11		C1 contains a non-breaking space
12		C8 contains white text
13		Formula in cell E4☛ =NOTNUMBER(B4:C8)
14
NOTNUMBER

Cell Formulas
Range	Formula
C4	C4	=CHAR(160)
E4:F8	E4	=NOTNUMBER(B4:C8)
B5	B5	=CHAR(32)
B6	B6	=NA()
C6	C6	=REPT(" ", 5)
B13	B13	=AFORMULATEXT(E4)
Dynamic array formulas.