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?

 

[Aladin Akyurek]

Try rather...

=IF(ISNUMBER(1/X2),IF(X2>0,"yes","no" ),"no")​

<strike></strike>

 

[Exceldeal]

if cells A1 is containing a number your formula must be checking for values for any -ve number to any +ve number or 0 to >0 numbers, while working with multithreaded or multilinked cells, remember that your first to the last cell should be formatted for numbers only, e.g A1 is containing a formula resulting any <=0 to any positive number and x2 is linked and calculating further, in next cell e.g x3 is containing your formula. Your result will be absolute.

 

[tburg73]

What if the cell (x2) sometimes returns text and sometimes a number? How do I get A2 to see the X2 as blank if X2 has no result? Is that possible?

if cells A1 is containing a number your formula must be checking for values for any -ve number to any +ve number or 0 to >0 numbers, while working with multithreaded or multilinked cells, remember that your first to the last cell should be formatted for numbers only, e.g A1 is containing a formula resulting any <=0 to any positive number and x2 is linked and calculating further, in next cell e.g x3 is containing your formula. Your result will be absolute.

 

[tburg73]

In grammatical terms something like... If x2<>blank,yes,no

 

[tburg73]

Actually I just saw this. Sorry. This might work if I can also add a if error to cover when the value is non numerical.

 

[Aladin Akyurek]

Actually I just saw this. Sorry. This might work if I can also add a if error to cover when the value is non numerical.

Did you try post #2 at all?

 

[tburg73]

Yes. But it didn't quite work when the value in x2 was non numerical. However I feel a bit retarded. I just changed the x2>0 to x2<>""
and it seems to be working.

Did you try post #2 at all?

 

[tburg73]

PS... Thank you!!

 

[Aladin Akyurek]

PS... Thank you!!

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