Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula Help Please
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 |