Norman Harker - 1 more question

[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?

 

[Norman Harker]

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.

 

[JennyP]

Norman - thanks heaps, although what happens if I don't
have any data in the "type" column at say d15?

 

[Peo Sjoblom]

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)