Forum Discussion
Excel is the nested if statement the correct choice ?
I am currently having trouble with using a nested if statement, I am thinking I may need to try a different statement to use, in order to generate what I am needing. I have provided two screen shots of what I am trying to accomplish. first is a usage rate. and the second is a min. capacity requirement. both are based on the user input of home sqft and number of bedrooms. the 2nd seems a little more in depth-in regards of the formula needed. any advise is welcomed, even if its just pointing me in the correct direction. Thank you !!
1 Reply
For the bands covered by the table you have two distinct calculations, one based upon the count of rooms and the other on size of premises. Calculate each and take the larger:
= MAX(
LOOKUP( Count-1, Bedrooms, Capacity ),
LOOKUP( Size, SizeThreshold, Capacity ) )
