Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Formula Help

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