Excel Formula (Advance)

[Hyz85]

Hi All,
need you expertise on below case.

This is breakdown of marks for task assigned.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Approve[/TD]
[TD]Reject[/TD]
[TD]Uncontactable[/TD]
[/TR]
[TR]
[TD]50%[/TD]
[TD]30%[/TD]
[TD]20%[/TD]
[/TR]
</tbody>[/TABLE]

if i assigned with 70 file/submission and result as below :-

[TABLE="width: 500"]
<tbody>[TR]
[TD]Approved[/TD]
[TD]15[/TD]
[TD]??%[/TD]
[/TR]
[TR]
[TD]Rejected[/TD]
[TD]16[/TD]
[TD]??%[/TD]
[/TR]
[TR]
[TD]Contactable[/TD]
[TD]39[/TD]
[TD]??%[/TD]
[/TR]
</tbody>[/TABLE]

how can i convert the percentage with guideline (50%/30%/20%) against with result?


you assistance highly appreciated.

 

[FormR]

and result as below :-

Hi, can you re-post that table but with your actual expected results in place of the question marks?

Include a description of how you arrive at those expected results if needed.

 

[Hyz85]

Hi, can you re-post that table but with your actual expected results in place of the question marks?

Include a description of how you arrive at those expected results if needed.

Hi MrExcel MVP,
the final result can be more than 100% or less than 100% depending on approval %, Rejection % & UTC % per submission
below are the expectation for final result.
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Approved[/TD]
[TD]15[/TD]
[TD]47%[/TD]
[/TR]
[TR]
[TD]Rejected[/TD]
[TD]16[/TD]
[TD]23%[/TD]
[/TR]
[TR]
[TD]Contactable[/TD]
[TD]39[/TD]
[TD]12%[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, the penny has not dropped for me - I think you are going to have to explain how you arrive at those results? i.e. what is the calculation?