May 27 2020 02:29 AM
Hi everyone,
Perhaps this is advice more than an excel formula, but wanted ideas of how others would display an actual of 133% when the target is 100% - i.e we should never go over 100%, so the actual tracking 33% too high. For context, we have a list of KPI's where we are showing 'Progress to Target' for many parts of the business and in most cases, its good to be over 100%, but this particular one, it is not.
Thanks!
Jenny
May 27 2020 06:01 PM
May 28 2020 03:32 AM
May 28 2020 04:17 AM
SolutionDepends on concrete goals and data structuring. You may apply conditional formatting rule which highlight cell(s) if the actual is more than target with some gap.
That could be data validation which won't allow to add actual if it's more than target with gap.
May 28 2020 04:17 AM
SolutionDepends on concrete goals and data structuring. You may apply conditional formatting rule which highlight cell(s) if the actual is more than target with some gap.
That could be data validation which won't allow to add actual if it's more than target with gap.