Can you create a formula to add 1 to the # you enter

[Guest]

Formula to add 1 to the number I enter into a cell. It keeps coming back as
circular reference

 

[Peo Sjoblom]

What's your formula, where is it and what cells are involved?

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

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.

 

[Don Guillett]

Now that clarifies the situation.

 

[Guest]

I don't Have a formula. I need to create one. Thanks

 

[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