Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You wish for cell D1 to read 2-Bedroom if the average of array A2:E2 is between 1000 and 1500. If not, 1-Bedroom. Please choose the
You wish for cell D1 to read 2-Bedroom if the average of array A2:E2 is between 1000 and 1500. If not, 1-Bedroom. Please choose the appropriate formula to place in cell D1.
- a.=IF(OR(AVERAGE(A2:E2)>=(1000:1500), "2-Bedroom","1-Bedroom")
- b.=IF(OR(AVERAGE(A2:E2)=(1000:1500),"2-Bedroom","1-Bedroom")
- c.=IF(AND(AVERAGE(A2:E2)>=1000,AVERAGE(A2:E2)<=1500),"2-Bedroom", "1-Bedroom")
- d.=IF(AND(A2=1000,A2=1500,AVERAGE(A2:E2),"2-Bedroom","1-Bedroom")
- e.None of the above
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