60.1K

Verified Solution

Link Copied!

Please just tell me what to type into each cell for each step. Thank you

In 14, use the IF(AND( for the following criteria: If AND criteria in H4 is TRUE, then return the text "Remodel", else return the text "No Remodel". As per instruction 1, Nest the formula from H4 into the IF function using Copy and Paste. Do not reference cell H4. Do this for all nested functions in this assignment. In K4, use the =OR( for the following criteria: Years Since Remodel > 5 OR Funds Available > 6000 In L4, use the IF(OR( for the following criteria: If OR criteria in K4 is TRUE, then return the text "Paint", else return the text "No Paint". As per instruction 1, Nest the formula from K4 into the IF function using Copy and paste. Do not reference cell K4. Do this for all nested functions in this assignment. In cell N4, use the =IF(IF to return one-of-three outcomes based on the Occupied field for the following criteria: if Occupied = "No", then return the text "Don't List" If Occupied = "Yes", then return the text "List" Occupied = "Move-in", then return the text "Wait List" Criteria Occupied -"NO" AND Years If AND criteriais Since TRUE, then Remodel "Remodelelse > "No Remode" Funds Available >> 5000 OR Years FOR criteria Since is TRUE, then Remodel Paint". else "No Paint if Rooms 1 then, "Single Rooms 2. then "Double. If Rooms) then "Multi-Family Houses Number of Rooms 350 Property Address HANDI OR FOR 1200 5506 395 4th Street South 5 147 Cross Street R16 Pleasant Street 782 Andover Court 530 Woodland Drive 067 Lakeshore 5506 Houses Apartments

Answer & Explanation Solved by verified expert

See Answer