formula not calculating
Posted by shane on November 13, 2001 3:56 PM
I have a formula it says ="T"ROUTERTOOLNAME That should give me a value T and then the value that ROUTERTOOLNAME looks to. For instance my value for ROUTERTOOLNAME is 12 that should make my value for my formula should say T12. IF the value for ROUTERTOOLNAME changes the formula will not show the change made until I go and click on ROUTERTOOLNAME in the formula and then enter it. It will at that point give me the new value.
Posted by Damon Ostrander on November 14, 2001 4:41 PM
Shane,
Your formula should be
="T" & ROUTERTOOLNAME
because you apparently want to concatenate the two strings together.
Damon
