Adding a value using external formula

A

altitude2k

Is there a formula that takes the value of one cell and can add it (o
whatever function) into another cell. For example a formula produce
the result "5" and you want that to be added onto the value of A
(which is, say, "3") without having to write a formula in A1 to sa
"and also add this value".

And also is there any way to do this but to add the value into a cel
with a formula. For example, cell "A1" has "=C1+C2" and produces th
result "12" and you want to add the value of "B1" (which is, say, "6"
and without making the formula "=C1+C2+B1" producing the value "18"
Instead having a formula in a seperate cell that takes the value o
"B1" and adds it to the value produced in "A1".

This will probably seem kinda pointless when you can just add an extr
bit to a formula, its just that if you knew exactly how complicated th
situation and the spreadsheet already is, then you'd see why I a
asking.

Thanks
 
I

IC

altitude2k said:
Is there a formula that takes the value of one cell and can add it (or
whatever function) into another cell. For example a formula produces
the result "5" and you want that to be added onto the value of A1
(which is, say, "3") without having to write a formula in A1 to say
"and also add this value".

And also is there any way to do this but to add the value into a cell
with a formula. For example, cell "A1" has "=C1+C2" and produces the
result "12" and you want to add the value of "B1" (which is, say, "6")
and without making the formula "=C1+C2+B1" producing the value "18".
Instead having a formula in a seperate cell that takes the value of
"B1" and adds it to the value produced in "A1".

This will probably seem kinda pointless when you can just add an extra
bit to a formula, its just that if you knew exactly how complicated the
situation and the spreadsheet already is, then you'd see why I am
asking.
Click to expand...
I'm not sure why you're trying to do this and I'm not sure you can. The
problem I see is that you would have to have some way of determining if the
amount has already been added to A1, otherwise each time the sheet
recalculates it would add it on again.
 
Top