Function/Equation

[Mike]

I'm looking for two functions/equations: 1) calculates an
equation in one cell and puts the result into the same
cell AND another cell, 2) calculates an equation in one
cell and puts the result into another cell. Can anyone
help?

 

[Frank Kabel]

Hi
both is not possible with formulas. Formulas can oly return a value to
the cell they reside in. You have to place a formula in the target cell

 

[BenjieLop]

This is probably what you can do:


<< 1) calculates an equation in one cell and puts the result into th
same
cell AND another cell, >>

Let's assume, Cell A1, contains your equation/formula. After Excel goe
through processing your formula, the result will be displayed in Cel
A1.

Now, if you want this result to appear in another cell, let's say, Cel
M1 ... go to cell M1 and enter the formula =A1. This will copy in M
what is in A1.


<< 2) calculates an equation in one cell and puts the result int
another cell.>>

Same procedure as #1 above.

Hope this will help you.