and another one!!

[Paul Cooke]

I have a workbook with 6 sheets. Sheet one being the master sheet.

In Sheet 1 (Master) cell "H3" has the following formula =Sheet2!F3 and is formatted as a date format (Eg. 31-03-06)

At the moment on "Sheet2!F3" the cell is blank / Empty but on the master the reference to this cell shows 00/01/00.

Is there anyway to formulate the master so that it does not put anything in the cell if the cell on the sheet it is referencing is blank / empty

Many thanks for any help offered

Paul

[Paul B]

Paul, here is one way,

=IF(ISBLANK(Sheet2!F3),"",Sheet2!F3)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul Cooke" <[email protected]> wrote
in message news:[email protected]...
>
> I have a workbook with 6 sheets. Sheet one being the master sheet.
>
> In Sheet 1 (Master) cell "H3" has the following formula =Sheet2!F3 and
> is formatted as a date format (Eg. 31-03-06)
>
> At the moment on "Sheet2!F3" the cell is blank / Empty but on the
> master the reference to this cell shows 00/01/00.
>
> Is there anyway to formulate the master so that it does not put
> anything in the cell if the cell on the sheet it is referencing is
> blank / empty
>
> Many thanks for any help offered
>
> Paul
>
>
> --
> Paul Cooke
> ------------------------------------------------------------------------
> Paul Cooke's Profile:
http://www.excelforum.com/member.php...o&userid=29268
> View this thread: http://www.excelforum.com/showthread...hreadid=545802
>

[[email protected]]

=if(isblank(Sheet2!F3),"",Sheet2!F3 )

[Paul Cooke]

Thanks Guys for the replies works perfectly

Thanks Again

Paul