How do I lock cell formulas???

J

John - Menifee, CA

For example, formaula is cell C1 adds cell A1 and B1. If I insert column
between B1 and C1, the formule will shift to D1. How do I make D1 formula add
cells B1 and C1 automatically. D1 currently will continue to add A1 and B1.
 
E

Elkar

You could use the OFFSET fuction.

In C1 enter:
=OFFSET(C1,0,-1)+OFFSET(C1,0,-2)

This adds the cells that are 1 column and 2 columns to the left of C1. When
you insert a column, the formula will be moved to D1, but still add the cells
that are 1 and 2 columns to the left.

HTH,
Elkar
 
Top