Spreadsheets??

[Janice]

Is there a Spreadsheet expert out there?

I wonder if anyone knows if you can enter a formula int one cell, that tells you the percentage increase between two cells?

I am hoping here I know, it would be such a help if there is a way to do this!!

 

[BevS97]

OK. I think it would just be

=(B1-A1)/A1 then apply the % format to it

I just tried it with A1=10, and B1=12 and got .2 which is displayed as 20% when you use the percent button.

or =((B1-A1)/A1)* 100 would give you 20 without the %button.


If that's not what you mean, then PM me and I'll send you an example.

Bev