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(F20,D2*G2,"")


"JBeaucaire" wrote:


Kanga 85;173051 Wrote:
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.

If the formula in H2 shows the text string "0" (without the quotes),
then your IF formula needs to treat that cell as text. Whatever is
showing in cell H2 needs to be EXACTLY tested. So if it's 0 then test
for "0", if it shows (0), then test for "(0)".

=IF(H2="0","sold","-")
or
=IF(H2="(0)","sold","-")

Now, if you change the formula in H2 to just result in numbers, then
your original formula will work. So look at that possibility, too.

Can you show me the formula from H2?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47936