"Transmitting" results

P

Prospero

Is there a way to write a formula that "sends" its result to anothe
cell.

For example:

Cell A1 contains a balance, £50
Cell B1 contains a deposit, £50
Cell A2 contains a formula to add A1 to B1 (=A1+B1)

Can I add something to the formula in A2 so that the result is copie
to another cell, for example C3?

I know that I could put =A2 in C3, but I would like to do this b
adding to the formula in A2 if possible
 
M

Myrna Larson

A formula can affect the value only in the cell that houses it.

You have proposed, you have to put =A2 in cell C3

An alternative would be an event macro but that seems like tremendous overkill
for the situation as you have described it.
 
Top