AnsweredAssumed Answered

If statement -> HELP

Question asked by DavidJoséMartins on Nov 12, 2014
Latest reply on Nov 13, 2014 by DavidJoséMartins

Title

If statement -> HELP

Post

Hello i'm new using filemaker and now i need to do a calculation. I have a variable "Age" that calculate in years the age of the person and now i want to do an if statment for this:

if age <= 10 , "Sub 10",

else if age >10 and <= 12 , "sub 12", 

else if age >12 and <= 14 , "sub 14",

else if age >14 and <= 16 , "sub 16",

else if age >16 and <= 18 , "sub 18",

else if age >18 and <= 35 , "Sénior",

else if age >35, "Veteran"

 

I don´t what the correct syntax that i need to use but can anyone help me to do this?

Thanks a lot

Capture.PNG

Outcomes