#value error

[mtpsuresh]

Hi,

In the cell B9 the value is 01/09/2006
In the cell C9 i enter the formula
=IF(ISBLANK(B9),"",DATE(YEAR(B9),MONTH(B9)+1,DAY(B9)))
In the cell D9 i enter the same formula
=IF(ISBLANK(C9),"",DATE(YEAR(C9),MONTH(C9)+1,DAY(C9)))

It works fine. But if i delete the value in B9, cell c9 displays blank.
But cell D9 displays #value error.

Is there any way to supress this error and display balnk value in D9.

Any help appreciated.

Suresh

 

[Dave Peterson]

Maybe you should just check to see if the cell looks blank:

=if(b9="","",...
=if(c9="","",...

=isblank() returns true only if the cell is really empty--no value and no
formula.

 

[xLBaron]

Try pasting in cell "D9"

=IF(ISBLANK(B9),"",DATE(YEAR(C9),MONTH(C9)+1,DAY(C9)))

 

[mtpsuresh]

Maybe you should just check to see if the cell looks blank:

=if(b9="","",...
=if(c9="","",...

=isblank() returns true only if the cell is really empty--no value and
no
formula.



http://www.excelforum.com/showthread.php?threadid=546758

Thanks Dave, it works as i expected. Thanks for your time and efforts

Suresh