Need help on formulla

%3CLINGO-SUB%20id%3D%22lingo-sub-3374078%22%20slang%3D%22en-US%22%3ENeed%20help%20on%20formulla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3374078%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20sets%20of%20targets%20and%20the%20total%20target%20achieved.%20Here%20I%20need%20to%20calculate%20the%20target%20achieved%20%25%20with%20targets%20whichever%20is%20higher.%20For%20ex%2C%20target%201-%20%2410%2C%20Target%202%20%2450%20and%20Target%20achieved%20is%20%24%2030.%20Here%20i%20need%20to%20calculate%20the%20target%20achieved%20%25%20on%20%2450%20since%20it%20is%20the%20higher%20value.%3C%2FP%3E%3CP%3ECan%20anyone%20suggest%20a%20formula%3F%3C%2FP%3E%3CP%3EI%20want%20to%20automate%20the%20process%20instead%20of%20manually%20doing%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3374078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3374139%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20on%20formulla%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3374139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F56951%22%20target%3D%22_blank%22%3E%40Adithya%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20what%20if%20the%20achieved%20amount%20equals%2010%3F%20Would%20that%20count%20as%20100%25%20of%20Target%201%20or%2020%25%20of%20Target%202.%3C%2FP%3E%3CP%3EAnd%20what%20if%2055%3F%20110%25%20of%20Target%202%2C%20I%20presume.%3C%2FP%3E%3CP%3EAnd%20are%20the%20targets%20fixed%20for%20all%20calculations%20or%20do%20they%20perhaps%20vary%20from%20person%20to%20person%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?