Determine "Blank" cell even if formula is entered

[gtd526]

Hello,

I need to alter $H4>0.1 (in I4 and I5) so if the cell(H:H) is blank then it doesn't populate.
I tried ISTEXT, but it doesn't work.
below is what I'm working with...

NFL.xlsm
	H	I
2	Pick	ATS
3
4		5
5		-5
6
7	ATL	10
Weekly Picks

Cell Formulas
Range	Formula
H4	H4	=IFERROR(IF(AND($A4=$AY4,IFERROR($BA4>=0.6,TRUE),IFERROR($BB4>=0.6,TRUE),IFERROR($BC4>=0.525,TRUE),IFERROR($BD4>=0.525,TRUE),$AU4=$AY$4),$A4,""),"")
H5	H5	=IFERROR(IF(AND($A5=$AY5,IFERROR($BA5>=0.6,TRUE),IFERROR($BB5>=0.6,TRUE),IFERROR($BC5>=0.525,TRUE),IFERROR($BD5>=0.525,TRUE),$AU5=$AY$5),$A5,""),"")
I4,I6:I7	I4	=IF(AND($F4="",$H4>0.1),$B4,"")
I5	I5	=IF(AND($F5="",ISTEXT($H5)),$B5,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H4:I35	Cell	does not contain a blank value	text	NO

 

[Fluff]

Use Isnumber rather than Istext

 

[gtd526]

Use Isnumber rather than Istext

ISNUMBER works if the cell is blank. What about when its populated from the formula (I5)?

NFL.xlsm
	H	I
2	Pick	ATS
3
4
5	TB
6
7
Weekly Picks

Cell Formulas
Range	Formula
H4	H4	=IFERROR(IF(AND($A4=$AY4,IFERROR($BA4>=0.6,TRUE),IFERROR($BB4>=0.6,TRUE),IFERROR($BC4>=0.525,TRUE),IFERROR($BD4>=0.525,TRUE),$AU4=$AY$4),$A4,""),"")
H5	H5	=IFERROR(IF(AND($A5=$AY5,IFERROR($BA5>=0.6,TRUE),IFERROR($BB5>=0.6,TRUE),IFERROR($BC5>=0.525,TRUE),IFERROR($BD5>=0.525,TRUE),$AU5=$AY$5),$A5,""),"")
I4:I7	I4	=IF(AND($F4="",ISNUMBER($H4)),$B4,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H4:I35	Cell	does not contain a blank value	text	NO

 

[Fluff]

Maybe

=IF(AND($F5="",$H5<>""),$B5,"")

 

[gtd526]

Maybe

=IF(AND($F5="",$H5<>""),$B5,"")

Perfect. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.