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