Not sure whether this is the right way of doing this but i'm trying to populate a field by looking at results from other existing fields and then taking a value from one of 6 variables. The Script I created is below but its throwing up an error on line 8 "Improper Statement Error might be due to missing ";" at end of line or incomplete expression. I cant see where i'm going wrong though:
KidsKick = if(Height <110,"Micro",if(Height <120,"Light",if(Height <130,"Welter",if(Height <140,"Middle",If(Height <150,"Heavy","Hyper")))));
ADULTF_U18M =If(Weight <50, "Micro",if(Weight <55, "Light", if(Weight <60, "Welter", If(Weight <65, "Middle", if(Weight <70, "Heavy", "Hyper")))));
ADULTM =If(Weight <58, "Micro",if(Weight <64, "Light", if(Weight <70, "Welter", If(Weight <76, "Middle", if(Weight <82, "Heavy", "Hyper")))));
U18F = If(Weight <45, "Micro",if(Weight <50, "Light", if(Weight <55, "Welter", If(Weight <60, "Middle", if(Weight <65, "Heavy", "Hyper")))));
U14M = If(Weight <40, "Micro",if(Weight <45, "Light", if(Weight <50, "Welter", If(Weight <55, "Middle", if(Weight <60, "Heavy", "Hyper")))));
U14F = If(Weight <35, "Micro",if(Weight <40, "Light", if(Weight <45, "Welter", If(Weight <50, "Middle", if(Weight <55, "Heavy", "Hyper")))));
if (Age_Group == "Kids Kickers" )
{
input.Division == KidsKick;
}
else if(Age_Group == "Adults" && Male_Female == "F")
{
input.Division = ADULTF_U18M;
}
else if (Age_Group == "Adults" && Male_Female =="M")
{
input.Division = ADULTM;
}
else if(Age_Group == "Under 18's" && Male_Female == "F")
{
input.Division == U18F;
}
else if (Age_Group == "Under 18's" && Male_Female == "M")
{
input.Division == ADULTF_U18M;
}
else if (Age_Group == "Under 14's" && Male_Female == "F")
{ input.Division == U14F;
}
else if ( Age_Group == "Under 14's" && Male_Female == "M" )
{
input.Division == U14M;
}