Hi Bernie Deitrick,

Using OR in that way may not work since each AND statement is looking at
different cells in the MIN part.

Cheers,
Shane Devenshire

"Bernie Deitrick" wrote:

Ooops, forgot the second formula

=IF(AND(OR(F9=3,F9=1,F9=2),MIN(EZ9,FA9,FD9,GA9,GB9 ,GC9)DATE(2009,5,1)),"GO","NO GO"))


Or, it you have a lot of integer values, something like:

=IF(AND(AND(F9=1,F9<=5),MIN(EZ9,FA9,FD9,GA9,GB9,G C9)DATE(2009,5,1)),"GO","NO GO"))

HTH,
Bernie
MS Excel MVP


"Bernie" wrote in message
...
I'm using the following formula if F8 =1 or 2:

=IF(AND(F8=1,MIN(EW8,FA8,FD8)DATE(2009,5,1)),"GO" ,IF(AND(F8=2,MIN(EW8,FA8,FC8,FD8)DATE(2009,5,1)), "GO","NO
GO"))

If F8 = 3, I want to use an "or" to shorten the formula below and add it to
formula above but I can't it out.

=IF(AND(F9=3,MIN(EZ9,FA9,FD9,GA9,GB9,GC9)DATE(200 9,5,1)),"GO",IF(AND(F9=3,MIN(FA9,FD9,GA9,GB9,GC9,G D9)DATE(2009,5,1)),"GO","NO
GO"))

Can't quite figure it out because of all the parenthesis'

Appreciate any help.