Hi, I found what was wrong with the equation.
Else-if statements requires a else statement at the end, and should never end with elseif.
Previously the equation read as:
if(Q2=="1",Q2a>=101 and Q2a<=150,
if(Q2=="2",Q2a>=151 and Q2a<=200,
if(Q2=="3",Q2a>=201 and Q2a<=250,
if(Q2=="4",Q2a>=251 and Q2a<=300))))
I changed it to:
if(Q2=="1",Q2a>=101 and Q2a<=150,
if(Q2=="2",Q2a>=151 and Q2a<=200,
if(Q2=="3",Q2a>=201 and Q2a<=250,
Q2a>=251 and Q2a<=300)))
The only change is coming in the last part of the equation.
The topic has been locked.