IFNUMBER

[schardt679]

IFNUMBER is like IFERROR for numbers. It returns Value_If_Number for number cells and the array itself otherwise.

Calls IFBLANK.
Other functions on minisheet: AFORMULATEXT.

Screen Tip/ Comment: =IFNUMBER(Array☛ range to check for numbers, [Value_If_Number]☛ value to return for number cells; =0) ⁂[]=optional; =default; =omit

=LAMBDA(Array,[Value_If_Number],
      LET(Arr, Array,          Val, Value_If_Number,
             Return, IF(ISNUMBER(Arr), Val,  IFBLANK(Arr, "")),
             Return
      )
  )

LAMBDA Examples.xlsx
	A	B	C	D	E	F	G	H	I
1		IFNUMBER
2
3		Original Data			Value_If_Number		Result
4		1			Letters only		Letters only
5			2					Letters only
6		#N/A					#N/A
7
8		123	ABC				Letters only	ABC
9
10		B5 contain space
11		C4 contains a non-breaking space
12		C8 contains white text
13		Formula in cell G4☛ =IFNUMBER(B4:C8, E4)
14
IFNUMBER

Cell Formulas
Range	Formula
G4:H8	G4	=IFNUMBER(B4:C8, E4)
B13	B13	=AFORMULATEXT(G4)
Dynamic array formulas.