W
Word HelpNeeded
Formula to add 1 to the number I enter into a cell. It keeps coming back as
circular reference
circular reference
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
What's your formula, where is it and what cells are involved?
--
Regards,
Peo Sjoblom
(No private emails please)
--
Regards,
Peo Sjoblom
(No private emails please)
W
Word HelpNeeded
I am working in Excel. There are select rows to add one to the number I
enter but I have a column for this number.
enter but I have a column for this number.
D
Don Guillett
Now that clarifies the situation.
W
Word HelpNeeded
I don't Have a formula. I need to create one. Thanks
G
Gord Dibben
Word
You can have a formula in a separate cell that adds 1 to whatever number you
enter in another cell.
In A2 enter =A1+1
In A1 enter a number....see A2 add 1 to that number.
Alternative.......place a 1 in a cell.
Copy that cell and select your other cell.
Paste Special>Add>OK>Esc.
Or you could use VBA to add 1 to the number each time you enter it.
I suspect there is more to this question than you have asked.
Gord Dibben Excel MVP
You can have a formula in a separate cell that adds 1 to whatever number you
enter in another cell.
In A2 enter =A1+1
In A1 enter a number....see A2 add 1 to that number.
Alternative.......place a 1 in a cell.
Copy that cell and select your other cell.
Paste Special>Add>OK>Esc.
Or you could use VBA to add 1 to the number each time you enter it.
I suspect there is more to this question than you have asked.
Gord Dibben Excel MVP