How to find the percentage difference

Solved
thomas 34 -  
 OVALIE83 -
Hello,

How to find the percentage difference between the actual amount and the expected amount?

Example: actual amount 340
expected amount 400
difference 60
difference in %?

Thank you
Configuration: Windows XP Internet Explorer 6.0

3 answers

  1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    The "classic" answer is: deviation=(actual-expected)/expected * 100
    In your example, the result will be -15%: (340-400)/400*100 = -15;

    a negative value means that we achieved less than expected, a positive value means we did better than hoped.
    It's nice, retirement! Especially in the Caribbean... :-)
    Raymond
    579
    1. ménéw
       
      %Ecart = (actual - planned)/100
      1
    2. J-F le bgey
       
      Hi, thank you, you helped me. Kisses krkr <3
      3