jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 33
Determining a % based off a value.
Cell C1 has the value that will change in $5,000 increments. Starting with $100,000
Cell B5 has the % (formula) that will change based on C1 value: This value should change according to the table below based off C1 value.
Appreciate any help!!
Table in A9:B9
<tbody>
</tbody>
Cell C1 has the value that will change in $5,000 increments. Starting with $100,000
Cell B5 has the % (formula) that will change based on C1 value: This value should change according to the table below based off C1 value.
Appreciate any help!!
Table in A9:B9
250,000 | 2.3% |
200,000 | 2.15% |
175,000 | 2.00% |
150,000 | 1.7% |
125,000 | 1.55% |
100,000 | 1.4% |
<tbody>
</tbody>