Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I NEED TO KNOW HOW TO DO THE BELOW 2 FORMULAS. WHEN YOU SEE THE SPREADSHEET I HAVE ENTER ONE FORMULA BUT IT IS NOT
I NEED TO KNOW HOW TO DO THE BELOW 2 FORMULAS. WHEN YOU SEE THE SPREADSHEET I HAVE ENTER ONE FORMULA BUT IT IS NOT COMING OUT CORRECTLY.
- 1.SelecttheSearchworksheetandthenthePetDepositcolumn.Createaformulatodeterminetherequiredpetdepositforeachunit.Iftheunithastwoormorebedroomsandwasremodeledafter2006,thedepositis$150;ifnot,itis$100.
- 2.The Recommendation column needs a nested function to indicate the remodeling status. If the apartment is unoccupied and has not been remodeled before 2006, then display "Please remodel" in the Recommendation column. Display " ~ No Change" for apartments that do not meet the former criteria.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started