Why is my formula shortened by Airtable?

[Davoies]

Why is my formula shortened by Airtable?

In my project, I want a point of contact assigned by province using the if formula below:

IF(Province="BC","Ashlee", 
IF(Province="AB","Karen"),
IF(Province="SK","Karen"),
IF(Province="MB","Karen"),
IF(Province="ON","Cody "),
IF(Province="QC","Ches"),
IF(Province="NU","Ches"),
IF(Province="YT","Ches"),
IF(Province="NT","Ches"),
IF(Province="NB","Leena"),
IF(Province="NS","Leena"),
IF(Province="NL","Leena"),
IF(Province="PE","Leena")
)

Could anyone tell me why AirTable only saved  the following and if there is anything missing to my formula for all the provinces to be included in the formula?
IF(Province="BC","Ashlee Larose", 
IF(Province="AB","Karen Ergus"))

Your time and knowledge are greatly appreciated.  Sonia

[Jason_Hill · Accepted solution]

I think something is amiss with your browser. It should not be cut off. I'll take the time to mention the "SWITCH" function. It's nice to use instead of "IF". It's a bit shorter. Below is a short example.

SWITCH(
 {Province},
   'BC', 'Ashlee',
   'AB', 'Karen',
   'SK', 'Karen',
   'MB, 'Karen',
     'No Province'
)

[ScottWorld]

It cuts off certain types of formulas that are invalid. Everything after the cutoff point was invalid.

[Davoies]

Thank you Jason_Hill.  Not sure about my browser.  It's a work computer maintained by an IT company.  Regardless, your workaround formula is perfect for what I need and I will practice using SWITCH()  for the first time.  🐵  Thanks a bunch!

Sonia

Thank you for your time.  

[Davoies]

Thank you ScottWorld for taking time to reply.  I will use a SWITCH () formula instead as suggested by @ScottWorld above.  🐵

Sonia