Formula using "except"

[scottywalker]

Ok

I have a confidential spreadsheet which is covered in formula so let me explain my problem

In A1 I have current jobs
In B1 I have employee on that task
In C1 I have work stage E.G. Active, Complete ETC
In D1 I have target completion date

The formula I am using is IF(B1="Naomi",If(D1<TODAY(),"Over","Under"),"")

So if the target implementation date was before today, it would come up as over target.

But i need this to take into account whether "C1" is complete. So if C1 was complete it would leave it blank

It needs to be a formula over a VBA

Any ideas

Cheers

 

[dispelthemyth]

Try

=IF(C1="Complete","",IF(B1="Naomi",IF(D1<today(),"over","under"),""))

Is the name reference supposed to be static on Naomi?</today(),"over","under"),""))

 

[scottywalker]

Sorted

Cheers Buddy