View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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