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 In 14, use the IF(AND( for the following criteria: If

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
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

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

Strategic Business Management From Planning To Performance

Authors: Gary Cokins

1st Edition

1937352358, 978-1937352356

More Books

Students also viewed these Accounting questions

Question

Why is desire important for success? (p. 271)

Answered: 1 week ago