I have run out of IF multiple statement within SharePoint list calculated column, I still have more sites to add.

I'm looking into a different way to build IF statement to fit all my sites (30 in total).

All sites refer to one of this three values: 5, 10, 15.

Trying this formula as an example:

IF(AND([Site_induction] = "UKI- Services- Chester TCC",OR([Site_induction] = "UKI- Services- Morden" TCC [Speed_limit] = "5mph")), "1", IF(AND([Site_induction] = "UKI- Services- Liverpool TCC",OR([Site_induction] = "UKI- Services- Manchester" TCC [Speed_limit] = "10mph")), "1", IF(AND([Site_induction] = "UKI- Services- Glasgow TCC",OR([Site_induction] = "UKI- Services- Oxley" TCC [Speed_limit] = "15mph")), "1",, "1", "0")))))

Any suggestions?

  • What is the issue here? Are you getting any error OR is it not showing the expected results? Oct 27, 2021 at 6:05
  • Ganesh, formula is giving me an error
    – Jose1978
    Oct 27, 2021 at 6:39

1 Answer 1


There are syntax errors in your formula. Try using this instead:

=IF(AND([Site_induction] = "UKI- Services- Chester TCC", OR([Site_induction] = "UKI- Services- Morden TCC", [Speed_limit] = "5mph")), "1", IF(AND([Site_induction] = "UKI- Services- Liverpool TCC", OR([Site_induction] = "UKI- Services- Manchester TCC", [Speed_limit] = "10mph")), "1", IF(AND([Site_induction] = "UKI- Services- Glasgow TCC", OR([Site_induction] = "UKI- Services- Oxley TCC", [Speed_limit] = "15mph")), "1", "0")))

Refer below documentations for syntax of IF, AND, OR, etc. functions:

  1. Calculated Field Formulas
  2. Examples of common formulas in lists
  • Hi @Jose1978, did you try this formula? does this help you? Oct 28, 2021 at 5:14
  • 1
    Ganesh, it works perfectly! Thanks a million as always
    – Jose1978
    Oct 28, 2021 at 12:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.