software

I'm trying to get some formula working but can't get rid of quot;#valuequot; in
result cells.cell C137 =
IF(details!T137gt;0;DATE(2005;7;14);(IF(details!U137 gt;0;DATE(2005;10;18);quot;quot;)))
cell J137 = IF(AND($D137lt;gt;quot;quot;;$F137=quot;quot;;C137 $A$153lt;=NOW());quot;Xquot;; quot;quot;)

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

How to avoid this #value to appear? I want quot;quot; or quot;Xquot; not #value

Bob

You have used semicolons in between formulas that's why it shows error.
IN EXCEL,USE COMMAS TO PARSE VALUES

For more queries and answers and share your views vist
groups.google.co.in/group/answers-for-everythinggt; a écrit dans le message de news:
...
gt; You have used semicolons in between formulas that's why it shows error.
gt; IN EXCEL,USE COMMAS TO PARSE VALUES

What do you mean ? using commas gives me errors. I'm not parsing values, I'm
using formulas...

Don't understand, sorry

Bob,

You could try

=IF(C137=quot;quot;;quot;quot;;IF(AND($D137lt;gt;quot;quot;;$F137=quot;quot;;C137 $A$1 53lt;=NOW());quot;Xquot;;quot;quot;))--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Bob Bedfordquot; gt; wrote in message
...
gt; I'm trying to get some formula working but can't get rid of quot;#valuequot; in
gt; result cells.
gt;
gt;
gt; cell C137 =
gt;
IF(details!T137gt;0;DATE(2005;7;14);(IF(details!U137 gt;0;DATE(2005;10;18);quot;quot;)))
gt; cell J137 = IF(AND($D137lt;gt;quot;quot;;$F137=quot;quot;;C137 $A$153lt;=NOW());quot;Xquot;; quot;quot;)
gt;
gt; the problem of my cell J137 is that it shows #value when cell C137 is quot;quot;
gt;
gt; How to avoid this #value to appear? I want quot;quot; or quot;Xquot; not #value
gt;
gt; Bob
gt;
gt;
gt;
quot;Bob Phillipsquot; gt; a écrit dans le message
de news: ...
gt; Bob,
gt;
gt; You could try
gt;
gt; =IF(C137=quot;quot;;quot;quot;;IF(AND($D137lt;gt;quot;quot;;$F137=quot;quot;;C137 $A$1 53lt;=NOW());quot;Xquot;;quot;quot;))

Thanks it works fine.

Cheers