percentual increase/decrease

[Portuga]

Hello,

How can I calculate automatically the % increase or decrease o
2values?

A1 = 100
B1 = 200
C1 must = 100%

Thanks

 

[JE McGimpsey]

One way:

=(B1-A1)/A1

formatted as a percentage.

Or, more efficiently:

=B1/A1 - 1

and, more robustly:

=IF(A1<>0, B1/A1-1, "NM")

 

[Tushar Mehta]

%change is defined as =(new value - old value)/old value

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions