I need a formula

[Annette]

I need a formula to find out the % increase for two number
for instance (8 & 12)

Thanks,
Annette

 

[s]

Try =(12/8)-1.

 

[annette]

I came up with .5%, so this would be my increase?
thanks

 

[Guest]

-----Original Message-----
I need a formula to find out the % increase for two number
for instance (8 & 12)

Thanks,
Annette
.
if I read you correctly..,

Where A1 = 8 and B1 = 12
formula is =((B1-A1)/A1)
In your example - ((12-8)/8)) = 4/8 = .5
Formulate cell as Percentage = 50%