I'm trying to get some formula working but can't get rid of "#value" in
result cells.


cell C137 =
IF(details!T1370;DATE(2005;7;14);(IF(details!U137 0;DATE(2005;10;18);"")))
cell J137 = IF(AND($D137<"";$F137="";C137+$A$153<=NOW());"X"; "")

the problem of my cell J137 is that it shows #value when cell C137 is ""

How to avoid this #value to appear? I want "" or "X" not #value

Bob