mashetterly
New Member
- Joined
- Apr 16, 2019
- Messages
- 1
I'm trying to write a formula that returns a % attainment based on a bonus achievement when referring to a target range.
The goal range is below from 0% to 200%. if the achievement was 265, the attainment% would be 100% (shown here). How do I write the formula so it calculates the exact % attainment for whatever "RESULT" I input? If the RESULT was 238, what would the Attainment % be?
<tbody>
[TD="class: xl66, align: center"] 0%
[/TD]
[TD="class: xl68, width: 81, align: center"] 90.0% [/TD]
[TD="class: xl66, width: 79, align: center"] 100% [/TD]
[TD="class: xl66, width: 97, align: center"] 200% [/TD]
[TD="class: xl69, width: 103, align: center"] RESULT [/TD]
[TD="width: 97, align: center"] Attainment % [/TD]
[TD="class: xl70, align: center"] 220.0 [/TD]
[TD="class: xl70, align: center"] 230.0[/TD]
[TD="class: xl70, align: center"] 265.0[/TD]
[TD="class: xl70, align: center"] 295.0[/TD]
[TD="class: xl71, align: center"] 265.0 [/TD]
[TD="class: xl72, align: center"]100%[/TD]
</tbody>
<tbody>
[TD="class: xl64, align: right"][/TD]
[TD="class: xl66, width: 81, align: right"][/TD]
[TD="class: xl64, width: 79, align: right"][/TD]
[TD="class: xl64, width: 97, align: right"][/TD]
[TD="class: xl67, width: 103"][/TD]
[TD="width: 97"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, align: right"][/TD]
</tbody>
The goal range is below from 0% to 200%. if the achievement was 265, the attainment% would be 100% (shown here). How do I write the formula so it calculates the exact % attainment for whatever "RESULT" I input? If the RESULT was 238, what would the Attainment % be?
<tbody>
[TD="class: xl66, align: center"] 0%
[/TD]
[TD="class: xl68, width: 81, align: center"] 90.0% [/TD]
[TD="class: xl66, width: 79, align: center"] 100% [/TD]
[TD="class: xl66, width: 97, align: center"] 200% [/TD]
[TD="class: xl69, width: 103, align: center"] RESULT [/TD]
[TD="width: 97, align: center"] Attainment % [/TD]
[TD="class: xl70, align: center"] 220.0 [/TD]
[TD="class: xl70, align: center"] 230.0[/TD]
[TD="class: xl70, align: center"] 265.0[/TD]
[TD="class: xl70, align: center"] 295.0[/TD]
[TD="class: xl71, align: center"] 265.0 [/TD]
[TD="class: xl72, align: center"]100%[/TD]
</tbody>
<tbody>
[TD="class: xl64, align: right"][/TD]
[TD="class: xl66, width: 81, align: right"][/TD]
[TD="class: xl64, width: 79, align: right"][/TD]
[TD="class: xl64, width: 97, align: right"][/TD]
[TD="class: xl67, width: 103"][/TD]
[TD="width: 97"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, align: right"][/TD]
</tbody>