Insert Row - Stop Automatic Formula Update


K

Kevin

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top