Expand my Community achievements bar.

SOLVED

If then question

Avatar

Former Community Member

I am trying to use an if/then statement using Fromcalc:

if (EFC < "1") then "2775"; elseif (EFC >= "1" and EFC <= "100") then "2750" endif

The first part will work fine, when I added the elseif I get error code 7008 that says "syntax error near token "2775" on line 1, column 25.

Can anyone tell me what I am doing wrong?  Also,

I want to continue the "elseif" statements many times for this field.  Is there a maximum number of times you can do an if/then for one particular field?

Thanks for your help.

1 Accepted Solution

Avatar

Correct answer by
Level 5

if you are trying to assign something then use

$ = "2775"

Dont use ; to terminate lines (use newlines instead)

Dont think there is any restriction on number of elseif

View solution in original post

2 Replies

Avatar

Correct answer by
Level 5

if you are trying to assign something then use

$ = "2775"

Dont use ; to terminate lines (use newlines instead)

Dont think there is any restriction on number of elseif

Avatar

Former Community Member

That worked!  Thank you so much for your help!