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.
Jun 15

About The Author

Registration is open for April Excel Bootcamp Webinars Register Now
left to take 50% off with coupon code: yearend50