I haven't been able to find info on how to code compound IF logic. Is code like the following valid?

FIELDB /P5 = IF (FIELDA GE 1 AND FIELDA LE 500) THEN FIELDA ELSE 0;

If that is not valid, then what is a valid way to code for something like this?

Thanks so much!

This message has been edited. Last edited by: webmeister,

That should be valid, you don't even need the parens. Are you having a problem with it?

As Pat asked, are you having a problem, is this in a COMPUTE or DEFINE? You can also use the syntax IF FILEDA FROM 1 TO 500 THEN FIELDA ELSE 0.

Thank you all for replying! I originally had code like this:

FIELDB /P5 = IF FIELDA (GE 1 AND LE 500) THEN FIELDA ELSE 0;

That didn't work, so I then had code like this:

FIELDB /P5 = IF (FIELDA GE 1 AND FIELDA LE 500) THEN FIELDA ELSE 0;

which also did not work, so I then wanted to try the IS_FROM logic, which does appear to work. I'll also try your suggestion, Leah.

Thanks so much again for replying and so quickly!

No such thing as IS_FROM logic, perhaps you mean this -

FIELDB/P5 = IF FIELDA FROM 1 TO 500 THEN FIELDA ELSE 0;

T

webmeister,
I just assumed that your code was in a define, if it is a compute the word COMPUTE is missing. If it is in a define what you have should work, assuming that FIELDA is numeric.

This message has been edited. Last edited by: PBrightwell,

I'll occasionally use boolean logic instead of compund IFs -
FIELDB/P5 = (FIELDA FROM 1 TO 500) * FIELDA;

T