View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Bernie is offline
external usenet poster
 
Posts: 47
Default For Shane Devenshire

Shane, ran the following formula and for F9=3 and it worked for the first
part; however, I entered data to ensure the second part of the formula when
F9=3 works and it gave me "NO GO" when it should've been "GO".

=IF(AND(F10=1,MIN(EW10,FA10,FD10)DATE(2009,5,1)), "GO",IF(AND(F10=2,MIN(EW10,FA10,FC10,FD10)DATE(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO GO")))

Did enter something wrong?