Getting #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.



mtpsuresh wrote:
>
> 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
>
> --
> mtpsuresh
> ------------------------------------------------------------------------
> mtpsuresh's Profile: http://www.excelforum.com/member.php...o&userid=31817
> View this thread: http://www.excelforum.com/showthread...hreadid=546758

--

Dave Peterson

[[email protected]]

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.



mtpsuresh wrote:
>
> 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
>
> --
> mtpsuresh
> ------------------------------------------------------------------------
> mtpsuresh's Profile: http://www.excelforum.com/member.php...o&userid=31817
> View this thread: http://www.excelforum.com/showthread...hreadid=546758

--

Dave Peterson

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

Suresh