View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Adding 2 cells proplem

If you're only adding 2 values together, then there's really no point in
using the SUM function.

In cell C1 enter:

=A1+B1

In cell E1 enter:

=C1+D1

HTH,
Elkar


"r" wrote:

i had a cell (C1) called "total" that displays the sum of two other cells..
i.e. the total cell got the formula "=sum(A1+B1)" ..

I then typed a value in cell (D1). Then I tried to add C1 to D1 in the cell
E1. I used segma sign to add the two cells. However, the cell E1 gave a
"Value!" error.

I don't know why..

when I tried the same in another computer, it worked well

I wonder if there is options to make the cell E1 show the result.