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

E

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!
 
G

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top