May 13 2022 11:00 PM
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 $ 30. Here i need to calculate the target achieved % on $50 since it is the higher value.
Can anyone suggest a formula?
I want to automate the process instead of manually doing it.
May 13 2022 11:37 PM
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?