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 ...
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 ) )