Thread
:
IF Formula Help Please
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
IF Formula Help Please
Try:
=IF(AND((AG2)="S",(AH2)="S"),"Y",IF(OR((AG2)="U",( AH2)="U"),"R",IF(SUM(--(AG2:AN2="S")),"G","R")))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann