Dynamic formula

  • Thread starter Thread starter Frank Pytel
  • Start date Start date
F

Frank Pytel

Hello;

I know I have asked this question before but can not seem to find the
answer. It may have been purged by now. I have done this before but can't
seem to figure out how.

I am working in 2003. I have three fields I would like to use to create a
formula

A14 B14 C14 D14
Number Number Operand Answer(by Formula)

therefore what I am trying to do is create a basic formula with a dynamic
operand.

=CONCATENATE("=(",A18,C14,B18,")") is the formula I am using. I have tried
with and without the parens.

Ex. Enter + in C14 and you get 1+1=2 D14 reads "2", Enter - and D14 reads
"0", Etc.

I thought that there may have been a set of keys to enter such as an array
formula. Can anyone please direct me in the correct direction?

Thanks

Frank Pytel
 
Two parts to this.

First, select cell D14. Now, go to Insert - Name - Define. Create a name (no
spaces), such as EvalForm
In the formula box, input:
=EVALUATE(A14&C14&B14)

Click "Add", ok out.
Now, in the cell D14, type:
=EvalForm

Note that you can copy this down, and it will still work.
 
Back
Top