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?
|