Please just tell me what to type into each cell for each step. Thank you
5 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 Number of Rooms field for the following criteria: if Number of Rooms = 1, then return the text "Single" If Number of Rooms = 2, then return the text "Double" If Number of Rooms >= 3, then return the text "Multi-Family" On the Apartments worksheet, complete columns H through N using the AND, OR, IF functions per the logic described in the following steps. A solution picture is provided in the download files. When nesting functions, use Copy and paste instead of using cell references In H4, use the =AND( for the following criteria: Years Since Remodel > 3 AND Occupied = "No" 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 Since HAND Since criteria is Remodel TRUE, then > AND Remode Occupied else "No Remode" Remodel > OR FOR criteriais Funds TRUE, then Available "Paint", ese "No >>6000 Paint if Occupied "No then "Dont List". If Occupied "Yes", then "List". If Occupied "Move-in", then Wait Apartments Number of Rooms Years since Rent Remodel 550l HANDLIFANDI OR FOR Funds Avalable Occupied 9000 No 4500 No 52001 Move-in 2 Property Address 7878 Street 97 Walnut Street 966 Street 395 Lake Avenue 702 Tanglewood D 127 Linden Avenue 395 Lake Avenue 800 350 2 52001 Move-in 60001 Houses Apartments
