Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

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 [email protected] 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.

[email protected] onmouseover=window.status=imagine … ;return(true)"

David Tod Sigafoos ~ SigSolutions

Cell: 503-341-2983

[email protected]

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

View this thread on the forum...