PHIL.Pearce84
Board Regular
- Joined
- May 16, 2011
- Messages
- 152
- Office Version
- 365
- Platform
- Windows
HI,
I am trying to get a multiple if statement to work but I've lost myself in the confusion, can anyone help?
Basically this is what I want to achieve;
1. If the completion date in Column J falls within any of the date ranges on the sheet (start date in D END DATE in I)
2. And if the values in G3,f3,e3 and C3 (which will continue up to row 2000 G4,5 ETC) then return yes otherwise no
This is my formula;
=IF(AND(J:J>=D3,I3<=I:I,"YES"),IF(G:G=G3,"YES"),IF(F:F=F3,"YES"),IF(E:E=E3,"YES"),IF(C:C=C3,"YES"),"No"))
I am trying to get a multiple if statement to work but I've lost myself in the confusion, can anyone help?
Basically this is what I want to achieve;
1. If the completion date in Column J falls within any of the date ranges on the sheet (start date in D END DATE in I)
2. And if the values in G3,f3,e3 and C3 (which will continue up to row 2000 G4,5 ETC) then return yes otherwise no
This is my formula;
=IF(AND(J:J>=D3,I3<=I:I,"YES"),IF(G:G=G3,"YES"),IF(F:F=F3,"YES"),IF(E:E=E3,"YES"),IF(C:C=C3,"YES"),"No"))