=D4 problem

[NewMan84]

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?

[Sandy Mann]

Try:

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

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"NewMan84" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>