How to find the percentage difference
Solved
thomas 34
-
OVALIE83 -
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
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 réponses
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
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
ménéw
%Ecart = (actual - planned)/100
J-F le bgey
Hi, thank you, you helped me. Kisses krkr <3
