Formula Help

[Pat]

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

 

[John C]

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)

 

[Sheeloo]

Do you want a solution for this particular case or for any formula?
You can perhaps build a formula but it will be too complex.

Using VBA will be easier.

In this particular case use;
="("&A1&"+"&A2&")*"&A3
to see
(1+2)*3

1,2 and 3 will change according to what is in A1,A2 and A3...

 

[Pat]

Well this formula is just an example it would have to work for many different
formulas but not really complex ones. I’m not really familiar with VBA could
you possibly point me to a good web site on VBA.

 

[Sheeloo]

Start with http://www.xlpert.com/toc.htm

Well this formula is just an example it would have to work for many different
formulas but not really complex ones. I’m not really familiar with VBA could
you possibly point me to a good web site on VBA.

 

[Pat]

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