Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

Please just tell me what to type into each cell for each step. Thank you image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Frank Woods Business Accounting Volume 1

Authors: Frank Wood, Alan Sangster

10th Edition

9780273681496

More Books

Students also viewed these Accounting questions

Question

Why are stereotypes so resistant to change?

Answered: 1 week ago

Question

1. What physical and mental tasks does the worker accomplish?

Answered: 1 week ago

Question

5. Why is the job done?

Answered: 1 week ago

Question

4. How does the worker do the job?

Answered: 1 week ago