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")))
|