Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
and another one!!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
and another one!!
=if(isblank(Sheet2!F3),"",Sheet2!F3 )
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
and another one!!
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
and another one!!
Thanks Guys for the replies works perfectly :) Thanks Again 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|