Norman Harker - 1 more question

  • Thread starter Thread starter JennyP
  • Start date Start date
J

JennyP

Thanks for your help Norman.
What if the date in or type cells are blank? I want the
value to show a blank cell where the formula is if no
information is entered into the "date in" and "type"
columns in the formula cell if these are blank.
how do i do that?
 
Hi JennyP!

Always pleased to help.

Use:
=IF(B1="","",B1+(C1*7))

When following up a "thread" in a newsgroup it's best to select the
thread and hit the "Reply" button. That way the thread keeps together.
Also, don't expect a reply from a named individual; we work together
here, backing one another up and allowing time off for good behaviour.
 
Norman - thanks heaps, although what happens if I don't
have any data in the "type" column at say d15?
 
See my original reply

=IF(COUNT(B1:C1)<>2,"",B1+C1*7)




--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top