errror

[yashgandhi]

=IF(OR(F2="Archive DATA - ECA",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Archive Data - Review",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Client Training",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(Z2),"False",IF(OR(F2="Data Deletion - ECA Hosting",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Data Deletion - Review Hosting",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="ECA Processing and ECA DB upload",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:T2),"False",IF(OR(F2="ECA to Native and Tiff Processing and Export",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:P2),ISBLANK(S2:U2),"False",IF(OR(F2="ECA to Native Processing and Export",O2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:P2),ISBLANK(S2:T2),"False",IF(OR(F2="ECA to Native Processing and Review DB Upload",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:P2),ISBLANK(S2:T2),"False",IF(OR(F2="Email Collection",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2),"False",IF(OR(F2="Forensic Image Analysis, Extraction and Reporting",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2),"False",IF(OR(F2="Image OCR",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(T2),ISBLANK(V2),"False",IF(OR(F2="Machine Translation",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(T2:U2),"False",IF(OR(F2="Manual File Conversion",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(T2:U2),"False",IF(OR(F2="Native and Tiff Processing and Export",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:U2),"False",IF(OR(F2="Native and Tiff Processing and Production Export",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:U2),ISBLANK(W2:X2),"False",IF(OR(F2="Native and Tiff Processing and Review DB Upload",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:U2),"False",IF(OR(F2="PRE ECA Processing",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2),ISBLANK(Q2:T2),"False",IF(OR(F2="Pre-Processed Data Analysis and Review DB Upload",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:Q2),ISBLANK(S2:T2),"False",IF(OR(F2="Production",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2:P2),ISBLANK(S2:U2),ISBLANK(W2:X2),"False",IF(OR(F2="Review DB Export",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(O2),ISBLANK(S2:T2),"False",IF(OR(F2="Tiff Conversion",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(T2:U2),"False",IF(OR(F2="User Creation",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(Z2),"False")))))))))))))))))))))))

 

[Peter_SSs]

Welcome to the MrExcel board!

It is an impressively long formula but we have
- no data to apply it to
- no idea what it is supposed to be doing
- no question from you