Forum Discussion
Solved
Formula Help
I need help from someone who knows the answer to my question below. I have this Nested IF Statement whereby I want to when needed, provide a separate answer if the statement is False. For instan...
Your Final Formula:
IFERROR(
IF(
OR(
AND(E2="HVAC",F2="AC",J2>85),
AND(E2="HVAC",OR(
F2="AC",
F2="Dehumidifier"
),
OR(
J2="No Power",
J2="Leaking",
J2="Noisy",
J2="Broken"
),
),
AND(E2="Appliance",OR(
F2="Dehumidifier",
F2="Dishwasher",
F2="Water Heater"
),
OR(
J2="No Power",
J2="Leaking",
J2="Noisy",
J2="Broken"
)
),
AND(E2="Appliance",OR(
F2="Dishwasher",
F2="Water Heater",
F2="Oven/Range"
),
J2="Not Heating"
),
AND(E2="Appliance",OR(
F2="Water Heater",
F2="Oven/Range"
),
OR(
J2="Gas Leak",
J2="Gas Smell"
)
),
AND(E2="Electrical",F2="Lights",OR(
J2="No Power",
J2="Broken"
)
),
AND(E2="Environmental",F2="Mold",OR(
J2="Present",
J2="Visible"
)
),
AND(E2="Plumbing",OR(
F2="Drain",
F2="Pipes",
),
OR(
J2="Leaking",
J2="Smell",
J2="Clogged",
J2="Noisy",
J2="Broken"
)
),
AND(E2="Structural",F2="Ceiling",OR(
J2="Leaking",
J2="Broken"
)
),
AND(E2="Structural",F2="Mold",OR(
J2="Present",
J2="Visible"
)
)
),
IFS(AND(E2="HVAC",F2="AC",AND(ISNUMBER(J2),J2>85)),
"LHS Temp is 86 and above",
AND(E2="HVAC",F2="AC",J2<=85),
"This is Not LHS Temp is 85 and below ",
AND(E2<>"HVAC",F2<>"AC",NOT(ISNUMBER(J2))),"LHS"
),
IFS(AND(E2="HVAC",F2="AC",J2>85),
"LHS Temp is 86 and above",
AND(E2="HVAC",F2="AC",J2<=85),
"This is Not LHS Temp is 85 and below ",
AND(E2<>"HVAC",F2<>"AC",NOT(ISNUMBER(J2))),"NOT LHS"
)
),
"")cheers
the syntax for IF():
IF([Condition],[ACTION IF TRUE],[ACTION IF FALSE])
Condition can be the value in the cell is "NW" then its true
Condition can be value in cell is >n or <n
Condition can be ISBLANK(J2) or NOT(ISBLANK(J2)) etc....
IF([Condition],[ACTION IF TRUE],[ACTION IF FALSE])
Condition can be the value in the cell is "NW" then its true
Condition can be value in cell is >n or <n
Condition can be ISBLANK(J2) or NOT(ISBLANK(J2)) etc....
I am still perplexed regarding the IF Statement issue I mentioned. This is because no matter what Cell I place the formula, in my eyes, I am still getting an invalid result. =IF(F5="NW","Yes","No") I am expecting a "Yes" if I know "NW" is in that cell. The same with =IF(F5=85,"Yes","No") I am expecting a "Yes" if I know 85 is in that cell. So when I have =IF(F5>85,"Yes","No") I am expecting a "Yes" if F5 has 86 in the cell and I am expecting a "No" if less than 85 or if "NW" is in that cell I am also expecting a "No" as the statement should evaluate to "Not True". Why will the formula result in "Yes" if F5 = 85 and result to "No" if the cell contains "NW". Change it to F5>85 it returns a "Yes". I simply do not understand.