Forum Discussion
Solved
Liner Interpolation Problem for Balanced Scorecard
Can anyone assist my problem? I have a balanced scorecard which I made and is almost perfect. The following criteria are crucial: Last Year - This is 50% of the allotted points Plan - This ...
Will_Sarty01 , if you mean this thread https://techcommunity.microsoft.com/t5/Excel/Balanced-Scorecard-Sliding-Scale-formula-problem/m-p/295449#M22540 where IngeborgHawighorst answered, I guess you shall just revert your formula in opposite direction, like
=IF(ytd<=stretch, 35, IF(ytd<=plan, 26.25+(plan-ytd)/(plan-stretch)*(35-26.25), IF(ytd<=last_year, 17.5+(last_year-ytd)/(last_year-plan)*(26.25-17.5), 17.5) ) )
Perhaps, no one can imagine such a complex situation without attaching your sample file. The absence of your sample file also explains why you received no conceivable response until now.
Thank you for your response. I will try to upload tomorrow. I wasn’t aware I could add a file in here
Will_Sarty01 , if you mean this thread https://techcommunity.microsoft.com/t5/Excel/Balanced-Scorecard-Sliding-Scale-formula-problem/m-p/295449#M22540 where IngeborgHawighorst answered, I guess you shall just revert your formula in opposite direction, like
=IF(ytd<=stretch, 35, IF(ytd<=plan, 26.25+(plan-ytd)/(plan-stretch)*(35-26.25), IF(ytd<=last_year, 17.5+(last_year-ytd)/(last_year-plan)*(26.25-17.5), 17.5) ) )Will_Sarty01 , you are welcome