Keep cell reference when insert row

A

Alex

How do I write a formula =B8-B12 to always subtract B8
from B12 even after I insert a row. When I insert a row,
formula changes to =B8-B13.

Thanks.
 

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

Similar Threads

correcting #value! problem 4
if true, if not nested if funcion 2
Repeat Cell Based on the Value-Excel 2003 3
Help with a formula (calculating totals based on individual percentages 7
Formula Help-Excel 2007 2
Payment calculation 1
#VALUE! in cell 5
Change Color of Cell based on Date and today's date. 1

Top