scottywalker
New Member
- Joined
- Feb 10, 2014
- Messages
- 18
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
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