IFBLANK

[schardt679]

IFBLANK is like IFERROR for blanks. It returns Value_If_Blank for blank cells and the array itself otherwise.

Search can made case sensitive but isn't by default.
Other functions on minisheet: AFORMULATEXT.

Screen Tip/ Comment: =IFBLANK(Array☛ range to check for blanks, [Value_If_Blank]☛ value to return for blank cells; =0) ⁂[]=optional; =default; =omit

=LAMBDA(Array,[Value_If_Blank],
      LET(Arr, Array,          Val, Value_If_Blank,
             Return, IF(Arr="", Val, Arr),
             Return
      )
  )

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

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