mikevalsoft
New Member
- Joined
- Feb 20, 2018
- Messages
- 7
< 2% | 2 to 5% | 5+ to 8% | 8+ to 11% | 11+% | |
0 to 10% | 0.6 | 0.8 | 1 | 1 | 1.25 |
10+ to 15% | 0.8 | 1 | 1 | 1.25 | 1.35 |
15+ to 25% | 1 | 1.25 | 1.25 | 1.35 | 1.5 |
25+ to 35% | 1.25 | 1.35 | 1.5 | 2 | 2.25 |
<tbody>
</tbody>
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