I need an Excel formula to calculate the percentage of decrease between the 2nd-to-last and last cells in row?

I will be continually inserting columns as data is collected so the formula must auto-update to always operate on the last 2 cells in the row.I need an Excel formula to calculate the percentage of decrease between the 2nd-to-last and last cells in row?
This will get the last cell from column A (assuming there are no blank cells in between data)

=INDIRECT("A"%26amp;COUNTA(A:A))



List will get the 2nd to last cell in column A

=INDIRECT("A"%26amp;COUNTA(A:A)-1)



These formulas will work when you add more data or insert rows.



Now the question becomes what do you exactly mean by "percentage of decrease between the 2nd-to-last and last cells". This can be one of two ways depending on which cell is decreasing



This will work if the 2nd-to-last cell is decreasing from the last cell

=(INDIRECT("A"%26amp;COUNTA(A:A)) - INDIRECT("A"%26amp;COUNTA(A:A)-1))/ INDIRECT("A"%26amp;COUNTA(A:A))



...Format the cell with this formula as Percent.



This will work if the last cell is decreasing from the 2nd-to-last cell

=(INDIRECT("A"%26amp;COUNTA(A:A)-1) - INDIRECT("A"%26amp;COUNTA(A:A)))/ INDIRECT("A"%26amp;COUNTA(A:A)-1)



Again, format the cell with this formula as Percent.I need an Excel formula to calculate the percentage of decrease between the 2nd-to-last and last cells in row?
→Very interesting. Maybe you could goggle that becasue I don`t know the answer. Sorry←