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.