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

[Eric D]

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!

 

[Eduardo]

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

=A1-A2

 

[Gord Dibben]

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

50 in A2

Copy A2 and select A1 then Paste Special>Subtract>OK>Esc

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


Gord Dibben MS Excel MVP

 

[Eric D]

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

 

[Gord Dibben]

See my reply.


Gord Dibben MS Excel MVP