Changing cell values based on another cell

[gfreed]

My question is lets say I want to get the sum of A1 and A2 and send the sum
to cell B5. How do I send or change the value of a cell without having my
equation in that cell.

another example my be that I do and IF statement and if I get a certain
result I want to clear cell B5. How do I do this please!

Thanks.

 

[Don Guillett]

FORMULAs only return values. In order to modify the cell the formula must be
in that cell. Otherwise use a macro.

 

[Roger Govier]

Hi

A formula can only return a value to the cell where the formula itself is
located.

If you are saying you want the result to be blank under certain conditions,
then in B5
=IF(A1+A2>100,"",A1+A2)
This would leave cell B5 empty, if A1+A2 exceeded 100
or
IF(AND(A1+A2>=20,A1+A2<=80),A1+A2,"")
In this case, if A1+A2 are between 20 and 80 inclusive, then show the
result, otherwise leave the cell empty.

is this what you mean?

 

[gfreed]

As you say, a formula can only return value to the cell where the formula
itself is located. So in saying this you mean that the SUM of two cells can
only be displayed in the cell where the formula is located! I've been reading
about LINKING cells so that cells will display the results of a cell with the
formula but I'm not sure yet. thanks for your help!

 

[gfreed]

As you say, a formula can only return value to the cell where the formula
itself is located. So in saying this you mean that the SUM of two cells can
only be displayed in the cell where the formula is located! I've been reading
about LINKING cells so that cells will display the results of a cell with the
formula but I'm not sure yet. thanks for your help!

 

[Roger Govier]

Yes, but if you Link the same applies
Say you put the following formula in cell A1 of Sheet2
=Sheet1!B5
That would return the value that is located in cell B5 of Sheet1, but that
is a formula itself, returning the value created by a formula in another
cell.