'If' problem

[Kanga 85]

I have an 'if' problem which I don't understand and cannot solve.

Cell H2 contains a formula delivering either a value (>0) or "".
The formula in I2 reads '=IF(VALUE(H2)>0,"sold","-")'. This works
correctly if value(H2)>0, but otherwise returns '#VALUE!'.

Thanks in advance for any help to what must be a simple problem.

 

[Max]

This should suffice:
=IF(OR(H2="",H2<=0),"-","sold")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[Max]

Replace the earlier with this:
=IF(OR(H2="",H2+0<=0),"-","sold")
since there's hints that H2 might return text nums
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

 

[T. Valko]

Try this:

=IF(N(H2)>0,"Sold","-")

 

[T. Valko]

My interpretation of the OP is that H2 will contain either a formula blank
or a number.

=IF(OR(H2="",H2+0<=0),"-","sold")

If H2 ="" then H2+0 will cause a #VALUE! error.

 

[Max]

If H2 ="" then H2+0 will cause a #VALUE! error.
Good point. I overlooked that.
Dismiss my 2nd response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

 

[Kanga 85]

Thanks to you all for your useful replies. The problem is now solved, and
you have provided me with further insight. The formula in H2 is:
=IF(F2>0,D2*G2,"")