Thread: IF(AND(Complex Formula in Error in data import before I process it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default IF(AND(Complex Formula in Error in data import before I process it
Hi J.P.,

Am Fri, 30 Jan 2015 18:57:02 -0800 (PST) schrieb JeanPierre Charron:

=IF(LEFT(L169,1)="P","E",IF(AND(LEFT(169,1)="C",AG 169="(Blank Value)"),"NoID",IF(LEFT(L169,1)="C",AG169,IF(LEFT( L169,1)="M",AG169,IF(LEFT(L169,1)="R",AG169))),D16 9)

I hope I understood your problem correctly.
Try:
=IF(OR(OR(LEFT(L169,1)={"P";"E"}),AND(LEFT(L169,1) ="C",AG169="")),"NoID",IF(OR(LEFT(L169,1)={"C";"M" ;"R"}),AG169,D169))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote