Dynamic formula

[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

 

[Luke M]

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.