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. |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com