Forum Discussion
Need help on formulla
I have two sets of targets and the total target achieved. Here I need to calculate the target achieved % with targets whichever is higher. For ex, target 1- $10, Target 2 $50 and Target achieved is $...
And what if the achieved amount equals 10? Would that count as 100% of Target 1 or 20% of Target 2.
And what if 55? 110% of Target 2, I presume.
And are the targets fixed for all calculations or do they perhaps vary from person to person?