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.
|