>, < not calculating correctly

[gtd526]

Hello,
Why is (AO) not calculating correctly? Looking at <, >.
Z:Z is formatted as "General".

Thank you.

NFL.xlsm
	A	B																							Y	Z															AO
4	DAL	5																							-3																TRUE
5	TB	-5																							5.2	0.2															FALSE
Weekly Picks

Cell Formulas
Range	Formula
Y4:Y5	Y4	=IFERROR(VLOOKUP($A4,'ATS Trends'!$A$2:$F$33,6,0),"")
Z4:Z5	Z4	=IFERROR(IF(B4>0,"",IF(AND($B4<0,$Y4<0),$B4+$Y4,IF(AND($B4<0,$Y4>0),$B4+$Y4,""))),"")
AO4	AO4	=Z4>Z5
AO5	AO5	=Z5>Z4

 

[Fluff]

It is calculating correctly, text is greater than a number in Excel.

 

[EFANYoutube]

=IFERROR(IF(B4>0,0,IF(AND($B4<0,$Y4<0),$B4+$Y4,IF(AND($B4<0,$Y4>0),$B4+$Y4,0))),0)
Try this in Z4 so you always get a 0 instead of a "" (text)

 

[gtd526]

It is calculating correctly, text is greater than a number in Excel.

I changed it to "ISNUMBER" and is working.
How can I determine if its >0?
Thank you.

NFL.xlsm
	A	B																							Y	Z															AO
4	DAL	5																							-3																TRUE
5	TB	-5																							5.2	0.2															TRUE
6	PHI	-10																							-3.5	-13.5															TRUE
7	ATL	10																							1.2																FALSE
8	PIT	3																							1.1																FALSE
9	BUF	-3																							4.6	1.6															TRUE
Weekly Picks

Cell Formulas
Range	Formula
Y4:Y9	Y4	=IFERROR(VLOOKUP($A4,'ATS Trends'!$A$2:$F$33,6,0),"")
Z4:Z9	Z4	=IFERROR(IF(B4>0,"",IF(AND($B4<0,$Y4<0),$B4+$Y4,IF(AND($B4<0,$Y4>0),$B4+$Y4,""))),"")
AO4:AO5	AO4	=X4>0
AO6:AO9	AO6	=ISNUMBER(Z6)

 

[Fluff]

How about

=AND(ISNUMBER(Z4),Z4>0)

 

[gtd526]

How about

=AND(ISNUMBER(Z4),Z4>0)

Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.