=D4 problem

  • Thread starter Thread starter NewMan84
  • Start date Start date
N

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?
 
Try:

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

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top