Add a cell to a fomula already in a cell and keep the formula
 

Is it possible to add a cell, say A2 which contains a number ($50.00) to cell
A1 which contains a formula (=500-45-55-100) and the answer be a new formula
(=500-45-55-100-50) so that it just adds the number in A2 to the end of the
current formula?

Thanks in advance!
--
Eric

Add a cell to a fomula already in a cell and keep the formula
 

Hi,
you will have to do it in a different cell like b2

=A1-A2

"Eric D" wrote:

Is it possible to add a cell, say A2 which contains a number ($50.00) to cell
A1 which contains a formula (=500-45-55-100) and the answer be a new formula
(=500-45-55-100-50) so that it just adds the number in A2 to the end of the
current formula?

Thanks in advance!
--
Eric

Add a cell to a fomula already in a cell and keep the formula
 

=500-45-55-100 in A1 returns 300

50 in A2

Copy A2 and select A1 then Paste SpecialSubtractOKEsc

Formula in A1 now looks like this =(500-45-55-100)-50 and returns 250


Gord Dibben MS Excel MVP


On Thu, 10 Dec 2009 10:38:01 -0800, Eric D
wrote:

Is it possible to add a cell, say A2 which contains a number ($50.00) to cell
A1 which contains a formula (=500-45-55-100) and the answer be a new formula
(=500-45-55-100-50) so that it just adds the number in A2 to the end of the
current formula?

Thanks in advance!

Add a cell to a fomula already in a cell and keep the formula
 

but that takes out the original formula. I need it to just add whatever is
in A2 to the current formula because the formula is what is most important in
this situation

cell A1 contains a formula (i.e. =500-45-55-100)

i want to be able to type an amount in cell A2 and it add it to the end of
the formula generating this formula (=500-45-55-100-50) so that i can copy
and paste the new formula over the old. The formula is what matters not the
sum. Does that make sense?

thanks
--
Eric


"Eduardo" wrote:

Hi,
you will have to do it in a different cell like b2

=A1-A2

"Eric D" wrote:

Is it possible to add a cell, say A2 which contains a number ($50.00) to cell
A1 which contains a formula (=500-45-55-100) and the answer be a new formula
(=500-45-55-100-50) so that it just adds the number in A2 to the end of the
current formula?

Thanks in advance!
--
Eric

Add a cell to a fomula already in a cell and keep the formula
 

See my reply.


Gord Dibben MS Excel MVP

On Thu, 10 Dec 2009 11:53:01 -0800, Eric D
wrote:

but that takes out the original formula. I need it to just add whatever is
in A2 to the current formula because the formula is what is most important in
this situation

cell A1 contains a formula (i.e. =500-45-55-100)

i want to be able to type an amount in cell A2 and it add it to the end of
the formula generating this formula (=500-45-55-100-50) so that i can copy
and paste the new formula over the old. The formula is what matters not the
sum. Does that make sense?

thanks