ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding 2 cells proplem (https://www.excelbanter.com/excel-discussion-misc-queries/81465-adding-2-cells-proplem.html)

r

Adding 2 cells proplem
 
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.


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com