Formula issue with the "OR" command
 

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(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO GO")))

Appreciate any assistance.

Formula issue with the "OR" command
 

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?
--
David Biddulph

"Bernie" wrote in message
...
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(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO
GO")))

Appreciate any assistance.

Formula issue with the "OR" command
 

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.

"David Biddulph" wrote:

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?
--
David Biddulph

"Bernie" wrote in message
...
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(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO
GO")))

Appreciate any assistance.

Formula issue with the "OR" command
 

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.


"Bernie" wrote in message
...
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.

"David Biddulph" wrote:

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?
--
David Biddulph

"Bernie" wrote in message
...
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(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO
GO")))

Appreciate any assistance.

Formula issue with the "OR" command
 

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.
--
David Biddulph

"Bernie" wrote in message
...
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.

"David Biddulph" wrote:

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?
--
David Biddulph

"Bernie" wrote in message
...
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(20 09,5,1)),"GO",IF(AND(F10=3,OR(MIN(EZ10,FA10,FD10,G A10,GB10,GC10)DATE(2009,5,1),MIN(FA10,FD10,GA10,G B10,GC10,GD10)DATE(2009,5,1))),"GO","NO
GO")))

Appreciate any assistance.