0

I'm quite new to this, could anyone point out why my calculated field isn't working

Im trying to use a matrix to output a value of critical, high, medium or low

The field Im using is ImpUrg_Total, this is my current failure

=IF(ImpUrg_Total<2,"Critical",IF(AND([ImpUrg_Total]>=2,[ImpUrg_Total]<4,"High",IF(AND([ImpUrg_Total]>=4,[ImpUrg_Total]<9,"Medium",IF([ImpUrg_Total]=>9,"Low"))))))
Improve this question

1 Answer 1

Reset to default
0

Use your formula like the following:

=IF(ImpUrg_Total<2,"Critical",IF(AND([ImpUrg_Total]>=2,[ImpUrg_Total]<4),"High",IF(AND([ImpUrg_Total]>=4,[ImpUrg_Total]<9),"Medium",IF([ImpUrg_Total]=>9,"Low"))))

Similar issue post for your reference:

  1. SharePoint 2013 calculated column adding multiple if statement

  2. Calculated Column with Nested IF statments

Improve this answer
2
  • Thanks for your help, it still didn't like it but was a lot closer, I changed it slightly to add in <13 as it will never be 13 or more so it worked like this Commented Oct 25, 2019 at 2:07
  • =IF(ImpUrg_Total<2,"Critical",IF(AND(ImpUrg_Total>=2,ImpUrg_Total<4),"High",IF(AND(ImpUrg_Total>=4,ImpUrg_Total<9),"Medium",IF(AND(ImpUrg_Total>=9,ImpUrg_Total<13),"Low")))) Commented Oct 25, 2019 at 2:07

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.