COMPLEX "if" formula

[mikevalsoft]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]< 2%[/TD]
[TD]2 to 5%[/TD]
[TD]5+ to 8%[/TD]
[TD]8+ to 11%[/TD]
[TD]11+%[/TD]
[/TR]
[TR]
[TD]0 to 10%[/TD]
[TD]0.6[/TD]
[TD]0.8[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1.25[/TD]
[/TR]
[TR]
[TD]10+ to 15%[/TD]
[TD]0.8[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1.25[/TD]
[TD]1.35[/TD]
[/TR]
[TR]
[TD]15+ to 25%[/TD]
[TD]1[/TD]
[TD]1.25[/TD]
[TD]1.25[/TD]
[TD]1.35[/TD]
[TD]1.5[/TD]
[/TR]
[TR]
[TD]25+ to 35%[/TD]
[TD]1.25[/TD]
[TD]1.35[/TD]
[TD]1.5[/TD]
[TD]2[/TD]
[TD]2.25[/TD]
[/TR]
</tbody>[/TABLE]

Column growth: X
Row growth: Y
Multiplier: Z

Given this table, I would like to write a formula that will equal to the number in the table. In other words, if I have 3.5% growth in the column section and 18% growth in the row section, then the number generate by the formula is equal to 1.25.

The purpose of this formula is to have someone change X and/or Y and be able to generate the multiplier in the table. As per my above example, the person could have 3.5% in the X cell and have 18% in the Y cell. The formula would then generate the multiplier (Z) of 1.25

Thank you very much for the help!!!! My initial thought is that it would have to do with an If(and(formula)...but I can<t seem to make it work

 

[Dryver14]

This is because you have removed a line from my original answer, the top row was 0 the second was 9.99 in this instance the formula looks at your number and if it is less than the next number it goes back up the row to the last number and returns that value