I'm working with a sizing chart that I'm trying to incorporate into excel, but I can't figure out the formula. We use Width by Height, so lets work with width first. If I have an item anywhere between 8:36(inches) I need the answer to be 1 section. If I have an item anywhere between 42:72(inches) I need the answer to be 2 sections. Now Height, If I have an item anywhere between 6:48(inches) I need the answer to be 1 section. If I have an item anywhere between 54:96 I need the answer to be 2 Sections.

So lets say Width is A3(Cell) and Height is A4(Cell)

Moving forward using both width and height, If the width exceeds 42 and the height exceeds 54 I need the answer to be 4 sections.

This is probably not enough information but hopefully someone can work with me.