I am creating a new column via the Formula Tool and adding the IF Then Statement Below.
If [Case Size]<'10' Then '9 & Under'
ElseIf [Case Size]>='10' and [Case Size]<'100' Then '10-99'
ElseIf [Case Size]<'200' Then '100-199'
Else '200 +'
EndIF
When I add the "ENDIF" condition at the end, I get an error stating the "<" in the "ElseIF[Case Size]<'200' Then '100-199' is an "Invalid Type in Operator <."
Any idea as to what I am doing wrong? It seemed pretty straight forward. The Data Type for [Case Size] is INT32.