0

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?

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

1 Answer 1

Reset to default
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
Improve this answer
2
  • Hi @Jose1978, did you try this formula? does this help you? Commented Oct 28, 2021 at 5:14
  • 1
    Ganesh, it works perfectly! Thanks a million as always Commented 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.