Question about greater than formula

[tburg73]

I am trying to use a formula in, let say, cell A1 such as =if(x2>0,"yes" ,"no" ). Now X2 contains a formula that gets its data based on other cells. So cell A1 always registers x2 as being greater than 0 and puts yes no matter what. How do I get cell A1 to see the formula result in x2 and not just the formula?

 

[tburg73]

I used x2<>"". ?

I guess you tried it and it's okay even when X2 is housing a text value.