simple formula problem

[Bob Bedford]

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


cell C137 =
IF(details!T137>0;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

 

[prabhuraaman]

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

 

[Bob Bedford]

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 Phillips]

Bob,

You could try

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Bedford]

Bob,

You could try

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

Thanks it works fine.

Cheers