Ralph_Belvedere
New Member
- Joined
- Jan 26, 2005
- Messages
- 1
I want to be able to type in a value into a cell and then have it add
a same value in each cell
So if C3 value is 55 and in cells D3 to L3 I start adding numbers
I want it to add 55 to each cell
So if I type 400 in D3 I want it to add 55 and so the value would automatically change to 455 when I shift to the next cell D4
So if I type 440 in D4 I want it to add 55 and so the value would automatically change to 495 when I shift to the next cell D5
I keep get the circular error message or when I type in the value
it wipes out the formula.
a same value in each cell
So if C3 value is 55 and in cells D3 to L3 I start adding numbers
I want it to add 55 to each cell
So if I type 400 in D3 I want it to add 55 and so the value would automatically change to 455 when I shift to the next cell D4
So if I type 440 in D4 I want it to add 55 and so the value would automatically change to 495 when I shift to the next cell D5
I keep get the circular error message or when I type in the value
it wipes out the formula.