If I want to label a range 0-60 "410A-L" and 61+ "410A-L" what is the proper IF function? The formula below has a parse error "Invalid type in operator >=", what am I missing here?
if [LS Tonnage] <=60 then "410A-M" elseif [LS Tonnage] >=61 then "410A-L" endif
This is the error I'm receiving now, could it be my prior substring?
@atarahoward seems to be the field LS Tonnage is string type, try the below formula
if [LS Tonnage] <= '60' then "410A-M"
elseif [LS Tonnage] >= '61' then "410A-L"
Else Null()
endIf