1

Can someone help me to apply the right formula to show the evolution of the paid amounts between two months, for instance :

In february :
Paid amounts = 30 Dollars
Turnover = 100 dollars
Evolution of Paid amounts are :  30%


In March :
Paid amounts = 20 Dollars
Turnover = 100 dollars
Evolution of Paid amounts are :  20%

Which formula is right To show the evolution between MARCH and FEBRUARY ?

(Paid ( March ) - Paid ( February ) ) * 100 / Paid ( February )

or

Percentage ( March ) - Percentage ( Fabruary )

Thank you :)

Andrei Fiordean
  • 223
  • 3
  • 14
Gol D. ALi
  • 11
  • 4
  • The meaning of "evolution" is quite vague. Can you clarify it? What do you expect if the paid amount for February was 0? In the first formula, there is a division by zero, and in the second formula, it says that there is a 20% increase, but none of these result make sense to me. – Gilles-Philippe Paillé Apr 12 '19 at 13:46
  • It has to be `(Paid ( March ) - Paid ( February ) ) * 100 / Paid ( February )`, as you're talking about the evolution of paid amount between months! – Am_I_Helpful Apr 13 '19 at 11:02
  • Thank you so Much, so finally the correct formula is : ( T1 - T0 ) * 100 / T0 – Gol D. ALi Apr 16 '19 at 15:33

0 Answers0