<div>
if it's 15% entered, what is the percentage to goal ?<br />
<br />
can you provide some examples?
</div>


if it's 15% entered, what is the percentage to goal ?

can you provide some examples?

29020325.xlsx

<div>
<div class="content wysiwyg-content">
Is it possible to have a percent to goal on a scale for example.<br />
<br />
the goal is 35%, the lower the better, the best someone can get is 0% the worst is 100% - if they get 100% it would be 0% to goal, if they get 35% it would be 100% to goal, but what i want is to stop from the percent to goal increasing drastically as they get lower - so 0% would ideally be 200% or something similar, but not 3500% to goal<br />
<br />
so the worst end would be 0% (100%), 100% to goal (35%), and the best possible would be 0% (200% to goal)<br />
<br />
Hope this makes sense.<br />
<br />
Thanks
</div>
</div>


Is it possible to have a percent to goal on a scale for example.

the goal is 35%, the lower the better, the best someone can get is 0% the worst is 100% - if they get 100% it would be 0% to goal, if they get 35% it would be 100% to goal, but what i want is to stop from the percent to goal increasing drastically as they get lower - so 0% would ideally be 200% or something similar, but not 3500% to goal

so the worst end would be 0% (100%), 100% to goal (35%), and the best possible would be 0% (200% to goal)

Hope this makes sense.

Thanks

excel + formula for percent to goal on a scale

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.