How can blank be greater than zero and therefore return TRUE?

[Excel_VBA]

Cell G10 has: =IFERROR(IF(H10>0,"Line",""),"")
Cell H10 has: =(IFERROR(VALUE(FIND("Contract Line Number:",A10)),"")) which evalutes to a blank or nothing.

Cell G10 returns "Line" as if the condition H10>0 is true (and H10 has a formula that evaluates to to a blank).

How can a blank be >0 ?

 

[T. Valko]

Cell G10 has: =IFERROR(IF(H10>0,"Line",""),"")
Cell H10 has: =(IFERROR(VALUE(FIND("Contract Line Number:",A10)),"")) which evalutes to a blank or nothing.

Cell G10 returns "Line" as if the condition H10>0 is true (and H10 has a formula that evaluates to to a blank).

How can a blank be >0 ?

A formula blank "" is an empty TEXT string. In Excel text has a higher value than any number.

="x">100000000 = TRUE

 

[Peter_SSs]

Cell G10 has: =IFERROR(IF(H10>0,"Line",""),"")
Cell H10 has: =(IFERROR(VALUE(FIND("Contract Line Number:",A10)),"")) which evalutes to a blank or nothing.

Cell G10 returns "Line" as if the condition H10>0 is true (and H10 has a formula that evaluates to to a blank).

How can a blank be >0 ?

A couple of observations about your formulas.

1. From what I can see your H10 formula has some () that are not needed. It also doesn't require the VALUE() function since FIND() already returns a value if the text is found. This should do just as well

=IFERROR(FIND("Contract Line Number:",A10),"")

(Note also that FIND is case-sensitive. If you don't want that shange it to SEARCH)

2. Perhaps you could use this in G10

=IF(H10="","","Line")