"Transmitting" results

  • Thread starter Thread starter Prospero
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
copy and paste the cell with formula ="1" 3
Excel formula, sum the value cell and if empty cell left blank 0
Display only unique values in CONCATENATE formula 4
Problem with Absolute reference 3
Searching alfanumaric cell contents and returning with a numaric v 21
Add a cell to a fomula already in a cell and keep the formula 4
Formula with Cell reference to include formating? 13

Back
Top