Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding specific cells | Excel Worksheet Functions | |||
adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
ADDING CELLS WHICH ARE <> THAN OTHER CELLS | Excel Worksheet Functions |