Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"))) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"))) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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"))) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Excel Programming Help | Excel Programming | |||
Advanced Programming | Excel Programming | |||
Excel Programming. | Excel Programming | |||
Excel Programming in VB | Excel Programming |