silentdragonfly
New Member
- Joined
- Dec 19, 2014
- Messages
- 28
Hi all!
I have a model that helps me calculate a bonus based on hitting certain ratios. I'm having trouble writing a formula to do the calculation. Here's how one line looks:
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>This part is easy as long as the actual ratio is one of the 3 ratios listed (1.15%, 1.00%, or 0.85%). I'm trying to figure out how to extrapolate what the % of goal reached would be if the actual delinquency ratio is say 1.018% (ie where does that fall between 0.20% and 0.30%)?
Thanks!
Peg
I have a model that helps me calculate a bonus based on hitting certain ratios. I'm having trouble writing a formula to do the calculation. Here's how one line looks:
<colgroup><col><col><col><col><col></colgroup><tbody> </tbody> What this means is if our delinquency ratio is 1%, take the employee's salary, multiply it by 5% (the weight of this line item) and multiply that by 0.30 (the % of goal reached). |
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
Thanks!
Peg