Adding 2 cells

[Boogmeister11]

How can i add one cell to another and have the sum appear in one of the cells that is being added?

Any help would be appreciated

[mangesh_yadav]

example ..?

lets say you have 1 in A1, 2 in A2. And you want to add A1 and A2.
Where do you want the result to be displayed. Can you be a little more clear.

Mangesh

[Boogmeister11]

i would like the answer to be displayed in A2.

So A2=(A1+A2)

Is this Possible?

[oldchippy]

i would like the answer to be displayed in A2.

So A2=(A1+A2)

Is this Possible?

That creates a circular reference. For what purpose is this to be used?

[starguy]

i would like the answer to be displayed in A2.

So A2=(A1+A2)

Is this Possible?

if you put =A1+A2 in cell A2, data in A2 will no more be there instead it will show you only that data which is in A1. (i-e =A1 will show you the same result).

[MrShorty]

This can usually be accomplished, but you'll need a VBA Worksheet_change or worksheet_calculate procedure to make it work.

[Boogmeister11]

This is for a pricing sheet and i want to be able to add the amount in A1 to all the cells that contain a price that needs to be changed.

How do i do a VBA worksheet_change or a worksheet_calculate procedure?