If then else syntax with multiple variables? 1

[SteveBabb]

Hi,

we are trying to create what we thought was a quick if then else loop to convert a string to a number and then multiply the values. Can anyone see why the formula below won't run? It says "The remaining text does not appear to be part of the formula". It runs without error if I remove the else. But without the else it runs all the code. Can you help?

numbervar stepmeasacr;
numbervar stepmeasrou;
numbervar stepnoacr;
numbervar stepnornd;
numbervar totalacr;
numbervar totalrnd;
numbervar totalinch;

If

NumericText({TechnicalSpec.StepMeasAcr})
and NumericText({TechnicalSpec.StepMeasRnd})
and NumericText({TechnicalSpec.StepNoAcr})
and NumericText({TechnicalSpec.StepNoRnd})

then

stepmeasacr := CDbl ({TechnicalSpec.StepMeasAcr});
stepmeasrou := CDbl ({TechnicalSpec.StepMeasRnd});
stepnoacr := CDbl ({TechnicalSpec.StepNoAcr});
stepnornd := CDbl ({TechnicalSpec.StepNoRnd});
totalacr := stepmeasacr * stepnoacr;
totalrnd := stepmeasrou * stepnornd;
totalinch := (totalacr * totalrnd) / 25.4;

else

0;

 

[synapsevampire]

You have a semicolon and lack of parenthesis problem.

I just tried this and it worked:

numbervar stepmeasacr;
numbervar stepmeasrou;
numbervar stepnoacr;
numbervar stepnornd;
numbervar totalacr;
numbervar totalrnd;
numbervar totalinch;

If

(NumericText("99999&quot
and NumericText("8888&quot
and NumericText("7777&quot
and NumericText("6666&quot)
then
(stepmeasacr := CDbl ("99999"
stepmeasrou := CDbl ("8888"
stepnoacr := CDbl ("7777"
stepnornd := CDbl ("6666"
totalacr := stepmeasacr * stepnoacr;
totalrnd := stepmeasrou * stepnornd;
totalinch := (totalacr * totalrnd) / 25.4)
else
0

Note the parens and lack of semicolons.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[SteveBabb]

Many thanks for that answer. You've fixed it )

Steve