Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you create a formula to add 1 to the # you enter
Formula to add 1 to the number I enter into a cell. It keeps coming back as
circular reference |
#2
|
|||
|
|||
Can you create a formula to add 1 to the # you enter
What's your formula, where is it and what cells are involved?
-- Regards, Peo Sjoblom (No private emails please) "Word HelpNeeded" wrote in message ... Formula to add 1 to the number I enter into a cell. It keeps coming back as circular reference |
#3
|
|||
|
|||
Can you create a formula to add 1 to the # you enter
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. "Peo Sjoblom" wrote: What's your formula, where is it and what cells are involved? -- Regards, Peo Sjoblom (No private emails please) "Word HelpNeeded" wrote in message ... Formula to add 1 to the number I enter into a cell. It keeps coming back as circular reference |
#4
|
|||
|
|||
Can you create a formula to add 1 to the # you enter
Now that clarifies the situation.
-- Don Guillett SalesAid Software "Word HelpNeeded" wrote in message ... 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. "Peo Sjoblom" wrote: What's your formula, where is it and what cells are involved? -- Regards, Peo Sjoblom (No private emails please) "Word HelpNeeded" wrote in message ... Formula to add 1 to the number I enter into a cell. It keeps coming back as circular reference |
#5
|
|||
|
|||
Can you create a formula to add 1 to the # you enter
I don't Have a formula. I need to create one. Thanks
"Peo Sjoblom" wrote: What's your formula, where is it and what cells are involved? -- Regards, Peo Sjoblom (No private emails please) "Word HelpNeeded" wrote in message ... Formula to add 1 to the number I enter into a cell. It keeps coming back as circular reference |
#6
|
|||
|
|||
Can you create a formula to add 1 to the # you enter
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 SpecialAddOKEsc. 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 On Mon, 7 Nov 2005 11:50:10 -0800, Word HelpNeeded wrote: Formula to add 1 to the number I enter into a cell. It keeps coming back as circular reference |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create formula to divide two rows autoaatically | New Users to Excel | |||
how to reference external refereces from a list | Excel Worksheet Functions | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |