Hi All,
I just want to create simple formula where excel should return value based on increasing / decreasing trend..
Details ..
We have highest and lowest score board where lowest value is better ( Payment due in months =<1.5 months is better than =>2.5 Months).
Here we want to give 15% additional discount if payment is made =<1.5 months, and it will reduce 1.5% on each increase intervention ( Table Below)
Please help me in creating this formula
<tbody>
</tbody>
I just want to create simple formula where excel should return value based on increasing / decreasing trend..
Details ..
We have highest and lowest score board where lowest value is better ( Payment due in months =<1.5 months is better than =>2.5 Months).
Here we want to give 15% additional discount if payment is made =<1.5 months, and it will reduce 1.5% on each increase intervention ( Table Below)
Please help me in creating this formula
Months | Score |
<=1.5 | 15% |
1.6 | 13.50% |
1.7 | 12% |
1.8 | 10.50% |
1.9 | 9% |
2 | 7.50% |
2.1 | 6% |
2.2 | 4.50% |
2.3 | 3% |
2.4 | 1.50% |
>=2.5 | 0% |
<tbody>
</tbody>