Formula issue with the "OR" command

  • Thread starter Thread starter Bernie
  • Start date Start date
B

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