Easy "percent change" calculation?

[mniedert]

It seems like I'm always trying to calculate the percent change between two values and for some reason I can't remember the proper formula.

I'd like to make my life easier by selecting a cell then have a custom button in the toolbar which would prmpt me to select the each of the two cells containing the values and it would put calculate the percent change for me and put in in the cell.

For example A1 has 375 in it and A2 has 300 in it. I select cell B1...hit the custom button and would be prompted for the cell containing the first number and after selecting A1, it would prompt me for the cell containing the second number (A2). Then B1 would display the percent change between the two numbers... in this case -20%

How can I do this?

 

[Lewiy]

How about a custom Function to do the job:

Function PercChange(iRange As Range, jRange As Range)
PercChange = Format(1 - (iRange / jRange), "#.00%")
End Function