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?

For Shane Devenshire
 

I'm not Shane, but see your later thread.

It is normally better to keep your discussion in the same thread so that
people can see the previous discussion, rather than starting new threads.
--
David Biddulph

"Bernie" wrote in message
...
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?