AnsweredAssumed Answered

Else if function

Question asked by toby91 on Apr 18, 2018
Latest reply on Apr 19, 2018 by fmpdude

Can anyone briefly tell me what I am doing wrong below I can not get it to work, it is saying the function cannot be found

 

If(Q8 >=0 and Q8 <=25;"0 - 25")

Else If (Q8 >=26 and Q8 <=35;"26 - 35")

Else if (Q8 >=36 and Q8 <=45;"36 - 45")

Else if (Q8 >=46 and Q8 <=55;"46 - 55")

Else if (Q8 >=56 and Q8 <=65;"56 - 65")

Else if (Q8 >=66 and Q8 <=75;"66 - 75")

Else if (Q8 >=76 and Q8 <=85;"76 - 85")

Else if (Q8 >=86;">86")

End if

Outcomes