What Statement to Use, IF Doesn't work 4

[mcaoneill]

Hi,

Here is what I have

Column
C D E F
Screening Cycle 1
Date Fail Cost Expected Start Date

I have so when a date is entered into Screening Date cost populates, I need column F to populate with a date of (C3 +21) this will work but what I also need is where there is no date in C3 F3 remains blank (rather than FALSE or VALUE)

Any ideas?

Thank you

Maureen

 

[carrr]

Look at the ISBLANK function (in the help file) used in conjunction with IF

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[SkipVought]

Hi,
[tt]
=If(isblank(c3),"",c3+21)
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi mcaoneill,

When you say IF doesn't work, what have you tried?

One of many ways to do this is [blue][tt]=IF(ISERR(C3+21),"",C3+21)[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[mcaoneill]

Thank you Skip & Tony,

Both of these solved the problem.

Have a great day

Maureen