IF Statement Help

[Jcraig713]

I have a maintenance schedule in excel split by quarter (1,2,3,4 etc). Along
the left-most column is worksite, Each quarter has a column, due on or before
and date completed column.

A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before Completed

I have a date in Qtr1 "due on/before" column. What I want to do is, I guess
it needs to be an IF statement for the date that goes in Qtr2 Due date such
as:

In D1... If the date in Completed Column(C1) > blank, then C1 +91, else B1+91

Any Suggestions?

 

[CLR]

Maybe this........

=IF(C1<>"",C1+91,B1+91)

Vaya con Dios,
Chuck, CABGx3

 

[Jcraig713]

Thanks is works beautifully!

I was using IF(C1>"",C1+91,B1+91)

What does the <> that the > doesn't?

 

[Don Guillett]

if you had numbers you could have used >0
<> means NOT equal to

 

[CLR]

You're welcome, thanks for the feedback.........

means "Greater than"

Vaya con Dios,
Chuck, CABGx3