Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
Can you please advise a way to automate the following scorecard metrics grading?
Metrics: Target Market Growth Rate
[b:2de2qnsf]Metrics Points[/b:2de2qnsf]
>20% 12
10%-20% 8
<10% 4
The market growth can range from negative 100% to 1000%, given the wide range of metrics inputs, is there a formula to convert whatever market growth rate entered to the 3 choices of points, 12, 8 and 4?
Thank you so much for your kind help! Read More