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

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

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

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

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

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

"Pat" wrote:

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