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

"Sheeloo" wrote:

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" 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