=D4 problem
 

Hi, I'm trying to make a sign in/out spreadsheet that will automatically
fill out our time sheets. My problem is, the cell I am mimiking is
blank, either "12:00 AM" or "0".

If the sign in cell is blank, the place on the timesheet where I put
"=D4" it prints either "12:00 AM" or "0" depending on which formatting
I use. Is there any way to make it print nothing if nothing is in D4?


--
NewMan84
------------------------------------------------------------------------
NewMan84's Profile: http://www.excelforum.com/member.php...o&userid=26471
View this thread: http://www.excelforum.com/showthread...hreadid=397402

Try:

=IF(D4="","",your formula)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"NewMan84" wrote in
message ...

Hi, I'm trying to make a sign in/out spreadsheet that will automatically
fill out our time sheets. My problem is, the cell I am mimiking is
blank, either "12:00 AM" or "0".

If the sign in cell is blank, the place on the timesheet where I put
"=D4" it prints either "12:00 AM" or "0" depending on which formatting
I use. Is there any way to make it print nothing if nothing is in D4?


--
NewMan84
------------------------------------------------------------------------
NewMan84's Profile:
http://www.excelforum.com/member.php...o&userid=26471
View this thread: http://www.excelforum.com/showthread...hreadid=397402