Changing cell values based on another cell
 

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.

Changing cell values based on another cell
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gfreed" wrote in message
...
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.

Changing cell values based on another cell
 

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+A2100,"",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?
--
Regards
Roger Govier

"gfreed" wrote in message
...
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.

Changing cell values based on another cell
 

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" wrote:

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+A2100,"",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?
--
Regards
Roger Govier

"gfreed" wrote in message
...
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.

Changing cell values based on another cell
 

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" wrote:

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+A2100,"",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?
--
Regards
Roger Govier

"gfreed" wrote in message
...
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.

Changing cell values based on another cell
 

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.

--
Regards
Roger Govier

"gfreed" wrote in message
...
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" wrote:

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+A2100,"",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?
--
Regards
Roger Govier

"gfreed" wrote in message
...
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.