ExcelBanter - Insert Row - Stop Automatic Formula Update

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Insert Row - Stop Automatic Formula Update (https://www.excelbanter.com/excel-worksheet-functions/194004-insert-row-stop-automatic-formula-update.html)

Kevin

Insert Row - Stop Automatic Formula Update

I have a formula in cell C5 that displays the percent change between two
values in the same column. The formula reads =-(C10-C9)/C10. When I insert
a in row 8, the row numbers in the formula in cell C5 automatically increase
by one to reflect the new cells =-(C11-C10)/C11.

When I insert a row I want the formula to keep analizing the newly formed
cells, instead of automatically updating the formula so that the original
cells are used. Any help would be greatly appreciated

dennis

Insert Row - Stop Automatic Formula Update

=-($C$10-$C$9)/$C$10

"Kevin" wrote:

I have a formula in cell C5 that displays the percent change between two
values in the same column. The formula reads =-(C10-C9)/C10. When I insert
a in row 8, the row numbers in the formula in cell C5 automatically increase
by one to reflect the new cells =-(C11-C10)/C11.

When I insert a row I want the formula to keep analizing the newly formed
cells, instead of automatically updating the formula so that the original
cells are used. Any help would be greatly appreciated

All times are GMT +1. The time now is 08:44 PM.