Need help on formulla

Copper Contributor

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. 

1 Reply

@Adithya 

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?