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

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
http://groups.google.co.in/group/answers-for-everything

a écrit dans le message de news:
...
You have used semicolons in between formulas that's why it shows error.
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="";"";IF(AND($D137<"";$F137="";C137+$A$1 53<=NOW());"X";""))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bob Bedford" wrote in message
...
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

"Bob Phillips" a écrit dans le message
de news: ...
Bob,

You could try

=IF(C137="";"";IF(AND($D137<"";$F137="";C137+$A$1 53<=NOW());"X";""))

Thanks it works fine.

Cheers