advanced excel programming
 

Help me please. I need to have a statement which says: if (Y13="SL",OR
("AL"),OR... how do I do it especially in the example attached???

=IF(AND((AH13="OK"),(X13="OK"),(Y13="PLUMB"),(AK13 =1),(AM13=1),(AO13=1)),"C:
Check in 5 years",IF((X13="REPLACE"),"A: Replace in 9
months",IF(AND((AH13="OK"),(X13="OK"),(Y13="SL"),( AK13=1),(AM13=1),(AO13=1)),"A: Repair in 9 months")))

advanced excel programming
 

=IF(AND((AH13="OK,X13="OK",Y13="PLUMB",AK13=1,AM13 =1,AO13=1),"C: Check in 5
years",IF((X13="REPLACE"),"A: Replace in 9
months",IF(AND((AH13="OK",X13="OK",OR(Y13="SL",Y13 ="AL"),AK13=1,AM13=1,A13=1
),"A: Repair in 9 months")))
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ralph" wrote in message
...
Help me please. I need to have a statement which says: if (Y13="SL",OR
("AL"),OR... how do I do it especially in the example attached???


=IF(AND((AH13="OK"),(X13="OK"),(Y13="PLUMB"),(AK13 =1),(AM13=1),(AO13=1)),"C:
Check in 5 years",IF((X13="REPLACE"),"A: Replace in 9

months",IF(AND((AH13="OK"),(X13="OK"),(Y13="SL"),( AK13=1),(AM13=1),(AO13=1))
,"A: Repair in 9 months")))

advanced excel programming
 

Ralph:
I had a different interpretation from the one that Bob Phillips had. Here
is my version:
=IF (
AND((AH13="OK"),(X13="OK"),(Y13="PLUMB"),OR((AK13= 1),(AM13=1),(AO13=1))),
"C: Check in 5 years",
IF(
(X13="REPLACE"),
"A: Replace in 9 months",
IF (
AND((AH13="OK"),(X13="OK"),(Y13="SL"), OR((AK13=1),(AM13=1),(AO13=1))),
"A: Repair in 9 months")))

Is this what you had in mind?


"Ralph" wrote:

Help me please. I need to have a statement which says: if (Y13="SL",OR
("AL"),OR... how do I do it especially in the example attached???

=IF(AND((AH13="OK"),(X13="OK"),(Y13="PLUMB"),(AK13 =1),(AM13=1),(AO13=1)),"C:
Check in 5 years",IF((X13="REPLACE"),"A: Replace in 9
months",IF(AND((AH13="OK"),(X13="OK"),(Y13="SL"),( AK13=1),(AM13=1),(AO13=1)),"A: Repair in 9 months")))

advanced excel programming
 

Yes, it's OR( x , y , z ), but your ()s don't match.
[I wonder if these tabs will work]
=IF(
AND(
AH13="OK,
X13="OK",
Y13="PLUMB",
AK13=1,
AM13=1,
AO13=1),
"C: Check in 5 years",
IF(
X13="REPLACE",
"A: Replace in 9 months",
IF(
AND(
AH13="OK",
X13="OK",
OR(
Y13="SL",
Y13="AL"),
AK13=1,
AM13=1,
A13=1),
"A: Repair in 9 months",
"Missing False Value")
)
)

Bob wrote:
=IF(AND((AH13="OK,X13="OK",Y13="PLUMB",AK13=1,AM1 3=1,AO13=1),"C: Check in 5
years",IF((X13="REPLACE"),"A: Replace in 9
months",IF(AND((AH13="OK",X13="OK",OR(Y13="SL",Y1 3="AL"),AK13=1,AM13=1,A13=1
),"A: Repair in 9 months")))


Ralph wrote
Help me please. I need to have a statement which says: if (Y13="SL",OR
("AL"),OR... how do I do it especially in the example attached???

=IF(AND((AH13="OK"),(X13="OK"),(Y13="PLUMB"),(AK1 3=1),(AM13=1),(AO13=1)),"C:
Check in 5 years",IF((X13="REPLACE"),"A: Replace in 9
months",IF(AND((AH13="OK"),(X13="OK"),(Y13="SL") ,(AK13=1),(AM13=1),(AO13=1))
,"A: Repair in 9 months")))



----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----