i tried your method and I got half way there the getformula fuction did work
but it gave me =(A1+B1)*C1. now how do i get it to sub in those numbers. ill
keep on messing around with it but any sugestions would be great

"John C" wrote:

A1 is A
B1 is B
C1 is C
A3: =(A1+B1)*C1
A2: is where you want the formula.
If you use the following UDF from the website
http://www.mvps.org/dmcritchie/excel/formula.htm
You could use this formula
A2: =GETFORMULA(A1)

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Pat" wrote:

Hey,

I am trying to create a formula that will allow me to sub in veriables into
a given equetion without solving for it. So in other words something like
this...
lets say
a=1
b=2
c=3

in one cell ill have
(a+b)*c

in the next cell ill have
(1+2)*3

and in the last cell ill actually solve it
9

that second step is giving me problems.

please help