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

The Holiday SALE is Here! Get 50% OFF Excel Models with code: 2025_50 Shop Now
left to take 50% off with coupon code: yearend50