I need help with the following statement that keeps throwing an error:
=IF(AND(CDR!Q2>=DATE('POC CDR'!O4,'POC CDR'!P4,'POC CDR'!Q4),CDR!Q2<=DATE('POC CDR'!O5,'POC CDR'!P5,'POC CDR'!Q5),(CDR!E2='mBox PCDR'!K30))(or(CDR!G2='mBox PCDR'!I4)(CDR!G2='mBox PCDR'!I5)(CDR!G2='mBox PCDR'!I6)(CDR!G2='mBox PCDR'!I7)(CDR!G2='mBox PCDR'!I8)(CDR!G2='mBox PCDR'!I9)(CDR!G2='mBox PCDR'!I10),CDR!F2,"0")
This is supposed to to first check against a date range and the value of a cell and then an or to validate against multiple cells.
Thanks in advance!
-EW
Bookmarks