Hi, great site.
I just wanted to find a quick answer to my problem.
ary: 1.
I remember from school there was a charecter before cell number to keep it from changing when dragging, while the second one changes in a calculation.
Like: =(B4+B19) but I want B4 to stay the same, and B19 to change as I drag it down...
2.
When calculating , If I want to add the current cell to my calculation, how can I do that?
Like: Cells have values, and I have one cell at the top. A1 is 1000 and A2 is 100, A3 is 330, A4 is 50.
On A2 I want something like A1+(currentA2)=(NewA2) in to A2, and drag this down with A1 as constant, and so on with other cells.
I hope I made myself clear with the questions, and If you don't understand my questions, it's ok .. but I am sure it is very easy to solve.. Please help ASAP/.
I just wanted to find a quick answer to my problem.
ary: 1.
I remember from school there was a charecter before cell number to keep it from changing when dragging, while the second one changes in a calculation.
Like: =(B4+B19) but I want B4 to stay the same, and B19 to change as I drag it down...
2.
When calculating , If I want to add the current cell to my calculation, how can I do that?
Like: Cells have values, and I have one cell at the top. A1 is 1000 and A2 is 100, A3 is 330, A4 is 50.
On A2 I want something like A1+(currentA2)=(NewA2) in to A2, and drag this down with A1 as constant, and so on with other cells.
I hope I made myself clear with the questions, and If you don't understand my questions, it's ok .. but I am sure it is very easy to solve.. Please help ASAP/.