Ask Question
17 February, 20:54

In cell I8, enter a nested logical function to display Need to Remodel if the apartment is unoccupied (No) AND was last remodeled more than 10 years ago (H3). For all other apartments, display No Change. Although Unit 101 was last remodeled over 10 years ago, the recommendation is No Change because the unit is occupied.

+1
Answers (1)
  1. 17 February, 21:23
    0
    The Function is given as

    =IF (AND (E8="No", G8>10),"Need to remodel","No Change")

    Explanation:

    The syntax of the IF condition in excel is given as

    IF (Test, If true, If false)

    So here the test is an and component such that the house has to be unoccupied which is indicated as E8 because the E column contain the occupancy of the apartments, and the G8 is the last remodeling time, so the test statement is the AND operation of the conditions as

    E8="No" indicating that house is unoccupied

    G8>10 indicating that the last remodelling was more that 10 years ago

    So the test is given as

    AND (E8="No", G8>10)

    Now the statement if the test true is the recommendation for to remodel, so

    "Need to remodel"

    Now the statement if the test is false is given as

    "No Change"

    So the overall function becomes

    =IF (AND (E8="No", G8>10),"Need to remodel","No Change")
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “In cell I8, enter a nested logical function to display Need to Remodel if the apartment is unoccupied (No) AND was last remodeled more than ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers