Percentage of target achieved

[dchatrie]

How would i write a formula to show percentage of target achieved for say and expense to income kpi, if my target is greater than my actual. Example: Ratio of expense to income target is 0.69 and the actual for the month is 0.57, what is the percentage of target achieved?

 

[Hui]

Dchatrie


The formula for % is X/Y*100

In your case

X is Actual = 0.57

Y is Target = 0.69


Therefore in Excel you can use a formula: =(0.57/0.69)*100

to get the percentage

or simply =(0.57/0.69) and then format the cell using the % Format button


Typically you would use cells as references and so it would become:

In your case

A1: X is Actual = 0.57

A2: Y is Target = 0.69


Therefore in Excel you can use a formula: =(A1/A2)*100

to get the percentage

or simply =A1/A2 and then format the cell using the % Format button

 

[dchatrie]

Thanks Hui