Formula issue with the "OR" command

[Bernie]

Using the formula below. The problem is when F10=3. The first part works
and I get a "GO" when the requirements are met; however, when the
requirements are met for the second part it still gives "NO GO". I'm not
sure where my error is on this. Is there too many arguements in this formula?


=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")))

Appreciate any assistance.

 

[David Biddulph]

If you're struggling with debugging, it's usually best to break your formula
into manageable chunks.
What value does the formula =MIN(FA10,FD10,GA10,GB10,GC10,GD10) return?

 

[Bernie]

if each has a date greater than 1 may 09, then "GO" will show in the cell, if
any do not have a date or a date greater than 1 may 09, the cell will show
"NO GO". the problem with the one cell equaling 3 is that cells EZ or GD can
be accepted with cells GA, GB, and GC.

 

[Fred Smith]

You didn't answer the question, Bernie.

To answer your question, no, you don't have too many arguments. Excel can
handle that many conditions. As you've found out, it's usually humans that
can't.

In addition to David's question, in the condition where you're checking
f10=3, why do you have separate Min functions? Why not combine them? If they
need to be separated, what's in EZ10 vs GD10? My bet is you have a
parenthesis out of place.

Regards,
Fred.

 

[David Biddulph]

So you are saying that when the condition is met, you get a "GO" result
(despite the question that you asked), and that when the condition isn't met
you get a "NO GO". Glad to hear that you've confirmed that the formula is
working correctly.