Cell P4 has a percentage in it. What I need to do is have a formula that if P4 falls between the table below the dollar amount is displayed in Q4. Any help You can offer would be greatly appreciated
Column R Column S Column T
<tbody>
</tbody>
Column R Column S Column T
Row 12 0% | 24% | $0.00 |
Row 13 25% | 26% | $1.00 |
Row 14 27% | 28% | $2.00 |
Row 15 29% | 30% | $4.00 |
Row 16 31% | 33% | $5.00 |
Row 17 34% | 36% | $6.00 |
Row 18 37% | 39% | $7.00 |
Row 19 40% | 100% | $8.00 |
<tbody>
</tbody>