For Shane Devenshire

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

David Biddulph

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.
 
Top