B
Bernie
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(2009,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,GA10,GB10,GC10)>DATE(2009,5,1),MIN(FA10,FD10,GA10,GB10,GC10,GD10)>DATE(2009,5,1))),"GO","NO GO")))
Did enter something wrong?
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(2009,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,GA10,GB10,GC10)>DATE(2009,5,1),MIN(FA10,FD10,GA10,GB10,GC10,GD10)>DATE(2009,5,1))),"GO","NO GO")))
Did enter something wrong?