Simon Ford
New Member
- Joined
- Nov 20, 2003
- Messages
- 3
How can I fix a cell value from another cell whose value will change e.g.
A1 = 300
B1 = 500
A1 TO CHANGE TO 500
B1 THEN CHANGES TO 0
A1 TO STAY AS 500 (FIXED)
A1 = 300
B1 = 500
A1 TO CHANGE TO 500
B1 THEN CHANGES TO 0
A1 TO STAY AS 500 (FIXED)