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 %...