Problem Using Multiple If Statements in Formulas (AREV Specific)
At 30 JUN 1999 02:00:48PM Mark Watford wrote:
Using AREV 1.16, writing a formula for a symbolic field
within a template. Below is the last lines of the formula
IF A + B + C + D=70 THEN
@ANS=4
END ELSE
IF A + B + C + D=30 THEN
@ANS=1
END ELSE
@ANS=0
END
At this point the formula will work fine, but if I insert
another IF clause instead of @ANS=0 such as IF A + B +C
+D=40 THEN
@ANS=3
END ELSE
@ANS=0
END The formula will not work it appears that it ignors
the first two IF statements and gives 0 as the answer to
every record. Can anyone tell where I am going wrong?
I really appreciate all of the responses to my questions
it has helped me immensely.
At 30 JUN 1999 02:12PM Warren wrote:
You're missing an END statement in the first example
At 30 JUN 1999 02:16PM dsig@teleport.com wrote:
Mark,
It looks like your first section of code could not work as it is not a completed if/then/else. You are missing an END
Other than that .. I have had many many nested ifs (not a good practice) and they have always worked.
dsig@teleport.com onmouseover=window.status=imagine … ;return(true)"
David Tod Sigafoos ~ SigSolutions
Cell: 503-341-2983
dsig@teleport.com
At 30 JUN 1999 02:37PM Victor Engel wrote:
I suggest reworking with CASE logic. Much easier to read.
At 05 JUL 1999 08:10PM Mark Watford wrote:
Thanks for the advice on using CASE logic that has solved
all of my problems and has helped me on other formulas.
Thanks Again