gaj104
Well-known Member
- Joined
- Nov 9, 2002
- Messages
- 864
Hi. I seem to have a problem. I have a simple formula subtracting from one cell from the other. However, when I insert a line and pull down one of the values the formula changes and references become offset.
Anyone know how I fix this?
Thanks
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | From this | |||||
2 | ||||||
3 | 100.00 | 300.00 | (200.00) | |||
4 | 100.50 | 350.30 | (249.80) | |||
5 | 200.00 | 500.00 | (300.00) | |||
6 | 600.00 | 600.00 | - | |||
7 | ||||||
8 | To this | |||||
9 | ||||||
10 | 100.00 | 100.00 | ||||
11 | 300.00 | (350.30) | <--- Line insereted and amount dragged down | |||
12 | 100.50 | 350.30 | (399.50) | |||
13 | 200.00 | 500.00 | (400.00) | |||
14 | 600.00 | 600.00 | 600.00 | |||
Sheet1 |
Anyone know how I fix this?
Thanks