rajkumar
02-13-2016, 10:26 PM
Hi Experts,
i need a custom function to evaluate performance based on targets and actual. i have attached the sample workbook.
for each evaluation parameters i have targets and actual, and permissible evaluation criteria like unacceptable, development required,met expectation etc.
what i want is a formula that can evaluate under which parameter (Pre Sales Activites) what percentage target vs actual has met and result should be unacceptable or development needed etc. in cell E6.
a formula for total of parameters compared again with same evaluation criteria and result should come in cell C13.
Please help.
Raj
i need a custom function to evaluate performance based on targets and actual. i have attached the sample workbook.
for each evaluation parameters i have targets and actual, and permissible evaluation criteria like unacceptable, development required,met expectation etc.
what i want is a formula that can evaluate under which parameter (Pre Sales Activites) what percentage target vs actual has met and result should be unacceptable or development needed etc. in cell E6.
a formula for total of parameters compared again with same evaluation criteria and result should come in cell C13.
Please help.
Raj