It depends on which set of conditions should have precedence. The way you
have the formula written:

=IF(AND((AG2)="S",(AH2)="S"),"Y",

takes precedence over everything else.

IF(AG2:AN2="S","G",

Does that mean if *every* cell in that range =S?

Try putting this test first:

=IF(AND(AG2:AN2="S"),"G",IF(AND(AG2="S",AH2="S")," Y",.............)


--
Biff
Microsoft Excel MVP


"Joe Gieder" wrote in message
...
Fist, thank you for your help.
I have this array formula in Z2:
{=IF(AND((AG2)="S",(AH2)="S"),"Y",IF(OR((AG2)="U", (AH2)="U"),"R",IF(AG2:AN2="S","G","R")))}
but it doesn't work. When it evals the AND and OR portions it works ok but
when S is in AG2:AN2 it doesn't give the result of "G", it stays a "Y".
What
did I do wrong? Also do I have the AND and OR functions written correctly?

Thanks in advance for your help
Joe