If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic formula
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 |
Thread Tools | |
Display Modes | |
|
|