formula problem

[Bernie]

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(2009,5,1)),"GO",IF(AND(F9=3,MIN(FA9,FD9,GA9,GB9,GC9,GD9)>DATE(2009,5,1)),"GO","NO GO"))

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

Appreciate any help.

 

[Bernie Deitrick]

Bernie,

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

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

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,GC9)>DATE(2009,5,1)),"GO","NO GO"))

HTH,
Bernie
MS Excel MVP

 

[Shane Devenshire]

Hi,

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

Howerver, you could also shorten these formula by

Putting the date into a cell and referencing it, for example, in your first
formula:

=IF(AND(F8=1,MIN(D1,D3,D5)>A1),,IF(AND(F8=2,MIN(D1,D3,D7,D5)>A1),,"No "))&"Go"

Where A1 contains the date.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Shane Devenshire]

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]

Thanks Shane. I added what you had to the other part and it worked.
Unfortunately the dates aren't static but I can see the logic to it. In this
worksheet eveything revolves what cell F's value is.

Appreciate your help.